Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular

© 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 Seamark¹  and Thomas Martens²

(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 ...