Syntax
Tutorial with example
In this video we will through the ISFILTERED function in DAX. This function is useful to detect when a column has been filtered and as shown in this video you can use it to set conditions when a column has been filtered.
Part2: Understand filter propagation in DAX
Download example file:
To get the files:
1. Go to Curbal Download Center > Dax Fridays
2. Get File #108
No download file available for the SUMIF video. Please use the northwind dataset to practice.
Remarks
- columnName is said to be filtered directly when the filter or filters apply over the column; 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 the column by filtering it as well.
- The related function ISCROSSFILTERED Function (DAX) returns TRUE when columnName or another column in the same or related table is being filtered.
Was this helpful?
Hello Ruth,
Thanks for the video !
When I use ISFILTERED in a measure it works but it doesn’t work when I use it in a column. It returns a wrong value.
Do you have any idea why it happens ?
Cheers
Didier
Hi Didier,
Maybe you are returning a table instead of a value?
/Ruth