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

7. Filtering Using Measures

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

Introduction

Throughout this chapter, various techniques are used to demonstrate possibilities that arise when measures are not just used to calculate a numeric value but their use is extended to flag items if they meet a condition or, worse, if they do not meet a certain rule, meaning they violate a rule. These techniques are ranging from simple filtering to a more complex concept of dynamic binning. A use case for the latter will be to create a visual (to be precise a ribbon chart) that counts the number ...

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.