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

5. Filtering in DAX

Philip Seamark1  and Thomas Martens2
(1)
UPPER HUTT, New Zealand
(2)
Hamburg, Hamburg, Germany
 

Introduction

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 rules appear ...

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.