From the course: Excel Business Intelligence: Power Pivot and DAX
Unlock this course with a free trial
Join today to access over 22,600 courses taught by industry experts.
Create explicit measures (Power Pivot) - Microsoft Excel Tutorial
From the course: Excel Business Intelligence: Power Pivot and DAX
Create explicit measures (Power Pivot)
- Alright, so now let's talk about the proper way to create explicit measures. So we're not gonna use the AutoSum shortcut anymore. Now we're gonna actually write DAX to create explicit measures through our Power Pivot tab. So, we'll be in the actual pivot table view not in our data model when we create these explicit measures. So in your Power Pivot tab, you'll see a button called Measures and when you click New Measure it will open up the Measure dialog box that looks like this. So at the top of the dialog box you've got information about the measure. Every measure gets assigned to a table so that you'll know where to find it in your Pivot Table field list. Let's give it a measure name again you can use spaces here if you choose and you've got an optional description. So that's kind of up to you if you want to use descriptions or not. Generally speaking, I'll add description for the more complicated measures that might not be so intuitive but I might just leave it blank for some of…
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)
Introduction to Power Pivot and DAX29s
-
Create a Power Pivot table5m 27s
-
(Locked)
Power Pivots versus normal pivots2m 48s
-
(Locked)
Introduction to Data Analysis Expressions (DAX)1m 12s
-
(Locked)
Calculated columns8m 39s
-
(Locked)
DAX measures2m 24s
-
(Locked)
Create implicit measures1m 59s
-
(Locked)
Create explicit measures (AutoSum)7m 8s
-
(Locked)
Create explicit measures (Power Pivot)7m 42s
-
(Locked)
Understand filter context9m 18s
-
(Locked)
Step-by-step measure calculation12m 6s
-
(Locked)
Recap: Calculated columns versus measures2m 29s
-
(Locked)
Power Pivot best practices1m 48s
-
(Locked)
-
-