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

Related Support Forum Posts

Displaying/Hiding Measures in Hierarchies
Dynamic Formatting of Selected Measure
Problem with Ranking (RankX), Showing all Customers

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

DOWNLOAD

To access our comprehensive DAX formula reference guide just insert your email address below. The resource will download immediately and we’ll also email it to you.