From the course: Excel Business Intelligence: Power Pivot and DAX

Unlock this course with a free trial

Join today to access over 22,400 courses taught by industry experts.

Create explicit measures (AutoSum)

Create explicit measures (AutoSum)

- [Instructor] Shifting gears into explicit measures. There are a couple of ways to create explicit measures. There is the lazy way and there's the proper way. So right now, I'm gonna 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 exist. 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 could see down here there's actually a Revenue Measure that had been created for this screenshot, and it just sits down here and it tells you, hey…

Contents