Cheat Sheets/Power BI/ISFILTERED
DAX function

ISFILTEREDDAX function reference

True if a column is filtered.

Syntax

dax
ISFILTERED(<table> | <column>)

Examples

dax
ISFILTERED(Sales[Region])
true / false
dax
IF(ISFILTERED(Product[Category]), "Filtered view", "Unfiltered")
Detects whether the user has sliced by Category

ISFILTERED on a whole table is true if any column of that table is directly filtered.

dax
IF(ISFILTERED('Date'), [Total Sales], BLANK())
Hides the total unless some date filter is active

Common mistakes & gotchas

Related DAX functions

From Filter context

← Back to the Power BI (DAX) cheat sheet