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.

DAX measures

DAX measures - Microsoft Excel Tutorial

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

Start my 1-month free trial Buy for my team

DAX measures

“

- Okay, time for another one of those critical, top five lectures in the whole course. We're gonna introduce DAX measures, which is the second place to use data analysis expressions. Now, simply put, measures are DAX formulas that you can use to create dynamic values within a PivotTable. Now, like calculated columns, and like any place you'd use DAX, measures reference entire tables or columns, so again, no A1-style references, but here's the thing. Unlike calculated columns, the measures don't actually live in the table. Instead you place them in the values area, and only the values area, of a PivotTable, so that they can dynamically calculate in each individual cell. This works in a very similar way to calculated fields in a traditional PivotTable. Now here's the most important concept, is that measures are evaluated based on the filter context of each cell in a Pivot, and that filter context is determined by the PivotTable layout. So, your filters, your slicers, any row labels, any…

Contents