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.
Tutorial (part2)
Download example file:
Download Power BI file (Part 1): here.
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.
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