ISFILTERED Function (DAX)

How does the ISFILTERED Function (DAX) work?

ISFILTERED Function (DAX) returns TRUE upon direct filtering of columnName. If the column does not have a filter or if the filtering occurs because a different column is filtered in the same table or in a related table then the function returns FALSE.

ISFILTERED Formula Syntax

ISFILTERED(<columnName>)

How do you use the ISFILTERED function?

It detects when a column has been filtered and can be used to set conditions when a column has been filtered.

Related Blog Posts

FILTER-CONTEXT
Using-Filter-Fields-Visual-Interactions-in-Power-BI-1
Understanding-Evaluation-Context-in-Power-BI

 

Considerations when using the ISFILTERED function

  • ColumnName is said to be directly filtered when a filter or filter is applied over a column; a column is said to be cross-filtered when a filter applied to another column in the same table or in a similar table influences the columnName by filtering the column.
  • The related function ISCROSSFILTERED (DAX) returns TRUE when filtering columnnName or another column in the same or related table.

Related Video Tutorials

Filtering By Fiscal Or Financial Year Months & Quarters In Power BI
Simple Filters w CALCULATE - (1.13) Ultimate Beginners Guide to DAX
How-To-Use-Virtual-Tables-With-COUNTROWS-in-Power-BI-DAX-Formula-Technique

Formula examples using the ISFILTERED function

EVALUATE { CALCULATE ( ISFILTERED ( Sales ), 'Product'[Color] = "Red" ) }
 

Related DAX Functions

ISCROSSFILTERED
FILTERS
HASONEFILTER

Related Course Modules

Ultimate-Beginners-Guide-To-PowerBI