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
Center of Excellence

DOWNLOAD


Download our comprehensive DAX Formula Reference Guide as perfect companion as you learn how to use DAX formulas within Power BI.


Download DAX Formulas Reference Guide
Download DAX Formula Reference Guide
Membership