Summary

This chapter developed and described several common classes of DAX measures, including date intelligence, dimension metrics, and ranking metrics. These measures utilized the fact and dimension tables accessed in Chapter 2, Connecting to Sources and Transforming Data with M, as well as the data model relationships defined in Chapter 3, Designing Import and DirectQuery Data Models. In addition to detailed measure examples, primary concepts of the DAX including filter context, row context, measure evaluation, and DAX variables were also reviewed. Moreover, examples of standard and DRLS models were shared, and DAX Studio was presented as a tool for testing and tuning DAX.

In the following chapter, Power BI reports will be created which ...

Get Mastering Microsoft Power BI now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.