© Philip Seamark, Thomas Martens 2019Philip Seamark and Thomas MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_5
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 ...