Tutorial with example
Have you ever wondered how and why filters move across tables and how you can modify the default behaviour? ….if yes, then don’t miss today’s DAX Fridays! video. Here is what we will cover: 1. Explain ISFILTERED function 2. Explain how filters move across tables 3. Explain ISCROSSFILTERED function 4. Modify default filter behaviour.
Download example file:
Download Power BI file: here.
- A column is said to be cross-filtered when a filter applied to another column in the same table or in a related table affects columnName by filtering it. A column is said to be filtered directly when the filter or filters apply over the column.
The related function ISFILTERED function (DAX) returns TRUE when columnName is filtered directly.