© 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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.