DAX function
ISFILTERED — DAX 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
- ISFILTERED only detects a direct filter on that column/table — it returns FALSE if the column is filtered indirectly through a relationship from another table, even though effective rows are restricted. Use ISCROSSFILTERED to catch that case too.
- ISFILTERED doesn't reveal how many values are selected — a slicer with three regions selected still returns TRUE, same as one; pair with HASONEVALUE or COUNTROWS(VALUES()) if the count matters.
Related DAX functions
From Filter context