Filtering Measures
Adam Aspin · Apress eBooks · 2022
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.