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.
- 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.
« Back to Index
Was this helpful?
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 ?
Ruth Pozuelo Martinez
Maybe you are returning a table instead of a value?