DAX Function Guide

ISFILTERED
Empty image or helper icon

Sam McKay

CEO & Founder

How does the ISFILTERED 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?

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

Related Blog Posts

Loading

Considerations when using the ISFILTERED?
  • 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

Loading

Formula examples using the ISFILTERED
EVALUATE { CALCULATE ( ISFILTERED ( Sales ), 'Product'[Color] = "Red" ) }
Related Courses

Loading