In this video, I’d like to demonstrate how you can fix incorrect card visual results and in the process discuss some best practices when using virtual tables within measures. Card Visuals are probably my favorite native visual in Power BI. They’re incredibly versatile, you can go from very simple to highly intricate, and they help a lot in data storytelling.
Brian
**** Video Details ****
00:00 Introduction
01:21 The data set
01:37 The model
02:00 Total sales measure
02:38 IF statement
06:55 Work in a tool like DAX Studio or Tabular Editor
08:10 Creating a virtual table with SUMX
08:36 Adding a new column to an existing table
09:44 Naming columns in a virtual table
10:54 Summing up an expression
11:59 Creating DAX query
13:56 Brian’s tips
**** Related Links ****
Enterprise DNA Practice Dataset External Tool - https://forum.enterprisedna.co/t/new-...
**** Learning Power BI? ****
FREE COURSE - Ultimate Beginners Guide To Power BI - http://portal.enterprisedna.co/p/ulti...
FREE COURSE - Ultimate Beginners Guide To DAX - http://portal.enterprisedna.co/p/ulti...
FREE - Power BI Resources - http://enterprisedna.co/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Online - http://portal.enterprisedna.co/
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
#EnterpriseDNA #PowerBI #PowerBITutorial #PowerBIDesktop #PowerBIDAX #DAX #DAXTutorial #BrianJulius #PowerBICardVisual #DataVisualization #SUMX
Watch video Fixing Card Visual Results In Power BI online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 02 March 2021. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 19,354 times and liked it 242 visitors.