© Philip Seamark 2018
Philip SeamarkBeginning DAX with Power BIhttps://doi.org/10.1007/978-1-4842-3477-8_6

6. Filtering

Philip Seamark1 
(1)
UPPER HUTT, New Zealand
 

Implicit Filtering

Filtering data is inevitable in modern reporting solutions. It is rare these days when you need to create a report that simply counts the rows or performs simple calculations over every row in a table.

One of the many excellent features of interactive tools such as Power BI is how they can apply filters interactively over the underlying data. If you click around on visuals in a report page, other visuals react and respond dynamically to show you new values representative of the selection you just made.

This is mostly implicit filtering that happens automatically due to ...

Get Beginning DAX with Power BI: The SQL Pro’s Guide to Better Business Intelligence now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.