Pro DAX and Data Modeling in Power BI: Creating the Perfect Semantic Layer to Drive Your Dashboard Analytics

© The Author(s), under exclusive license to APress Media, LLC, part of Springer Nature 2023

A. AspinPro DAX and Data Modeling in Power BIhttps://doi.org/10.1007/978-1-4842-8995-2_9

9. Filtering Measures

Adam Aspin¹  

(1)

STAFFORD, UK

 

One of the most powerful aspects of measures in DAX is that they can be tweaked and tuned to filter the output that they deliver. This means that you can use them to create targeted calculations that only display the results based on a specific subset of the data in the data model - rather than all the data defined by any implicit filter selection. This opens the doors to endless ways to compare and contrast results and consequently deliver in-depth analysis of your data.

The art behind the extension of measures is to ...