From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Unlock this course with a free trial

Join today to access over 24,300 courses taught by industry experts.

Create explicit measures (Power Pivot)

Create explicit measures (Power Pivot) - Microsoft Excel Tutorial

From the course: Excel Business Intelligence: Power Pivot, DAX and Data Modeling

Start my 1-month free trial Buy for my team

Create explicit measures (Power Pivot)

“

- [Instructor] Now let's talk about the proper way to create explicit measures. So we're not going to use the AutoSum shortcut anymore. Now we're going to actually write DAX to create explicit measures through our Power Pivot tab. So it'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'll open up the measure dialogue box that looks like this. So at the top of the dialogue box, you've got information about the measure. Every measure gets assigned to a table so that you know where to find it in your pivot table field list. It's given 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 a description for the more complicated…

Contents