© Philip Seamark, Thomas Martens 2019
Philip Seamark and Thomas MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_5

5. Filtering in DAX

Philip Seamark and Thomas Martens2
UPPER HUTT, New Zealand
Hamburg, Hamburg, Germany


Power BI does a fantastic job of allowing a report author to create a series of visuals that provide ways for an end user to explore a data model using a drag-and-drop approach. Sooner or later, there is a requirement that involves the same author adding some form of filtering to a DAX calculation.
This chapter explores and attempts to explain the concepts and hopefully clarifies a few nuances of the mysterious world of calculation-based DAX filtering along the way.
At first glance, filtering ...

Get Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.