From the course: Power BI Data Modeling with DAX
Unlock the full course today
Join today to access over 24,000 courses taught by industry experts.
Display the measure in a matrix - Power BI Tutorial
From the course: Power BI Data Modeling with DAX
Display the measure in a matrix
- [Instructor] Let's use this total sales measure that we created in a visualization. What I'd like to do is add a matrix because that gives me real numbers to look at as opposed to a beautiful chart visualization. They often look good to me whether they're correct or incorrect. So I'm going to choose total sales and notice that it gives me a chart. I'm simply with that chart visualization selected going to click on Matrix. And that is the total for total sales. But now I'd like to actually have total sales split out a little bit so that I'm looking at total sales by brand. So I'm going to choose brand name, total sales by brand. I'm going to give this a little bit more space so that it all works. And that looks beautiful. Here are my brands, here are our total sales. If I wanted to choose something other than brand I could. We could turn off brand and choose manufacturer. That looks good. Or I could choose…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
(Locked)
Create a measure with SUM2m 47s
-
(Locked)
Understanding DAX syntax1m 51s
-
(Locked)
Display the measure in a matrix1m 15s
-
(Locked)
Format a measure1m 33s
-
(Locked)
Create measures with COUNT and COUNTROWS3m 23s
-
(Locked)
Delete or edit a measure4m 29s
-
(Locked)
Check your data with COUNTBLANK1m 36s
-
(Locked)
Create a measure with DISTINCTCOUNT2m 28s
-
(Locked)
-
-
-
-