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,900 courses taught by industry experts.

Create explicit measures (AutoSum)

Create explicit measures (AutoSum) - 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 (AutoSum)

“

- [Instructor] Okay, shifting gears into explicit measures, there are a couple ways to create explicit measures. There's the lazy way and there's the proper way. So right now I'm going to show you very quickly the lazy way and then we won't use this approach ever again through the rest of the course. But I feel obligated to show you just so that you know it exists. Now consider this Data view from the data model. Note this pane at the bottom, which you may have seen earlier in the course and been a little confused by. Which I don't blame you, it's kind of a strange layout, but they call that the Measures Pane, or the calculation area, which you can actually turn it on and off right here in this button that says calculation area in the Home tab. And as we start creating measures, they'll start populating down here in the Measures Pane. You can see down here there's actually a revenue measure that had been created for this…

Contents