From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Unlock the full course today

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

DAX measures

DAX measures - Power BI Tutorial

From the course: Advanced Power BI: DAX Language, Formulas, and Calculations

Start my 1-month free trial Buy for my team

DAX measures

“

- [Instructor] DAX measures are portable stored formulas in our Power BI model. Measures often look the same as DAX columns when we add them to visuals or tables. Unlike columns, however, DAX measures don't take up a lot of memory in Power BI models, because they don't occupy a physical column in a data table. There are three key points to keep in mind when understanding and utilizing DAX measures. First, DAX evaluates measures against the data source, not against the PivotTable, for example. Second, DAX calculates each measure independently. Third, when we add a measure to a visual, like a table or a matrix, DAX evaluates each pivot coordinate through the same logical iteration process for each cell that references a DAX measure. One approach that I've found very helpful when I create Power BI models is having at least one separate table in the Fields pane that contains only DAX measures. I recommend this approach to…

Contents