ISFILTERED

« Back to Glossary Index

Google+

Twitter

Facebook

Syntax

ISFILTERED(<columnName>)

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.

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.

Was this helpful?

[Total: 0 Average: 0/5]