Back to Roadmap
Level 2 — Working With Filters+75 XP
Lesson 5
5. REMOVEFILTERS
Modern, intention-revealing filter removal modifier.
The Concept
REMOVEFILTERS is an alias for ALL specifically designed as a filter modifier in CALCULATE.
Example DAX:
Sales Without Product Filter =
CALCULATE(
[Total Sales],
REMOVEFILTERS(Products)
)REMOVEFILTERS makes your DAX more readable because it explicitly signals that you are clearing filters rather than returning a table.
Try It Yourself
Calculate [Total Sales] while removing all filters on the Products table using REMOVEFILTERS.
fx
[fx]REMOVEFILTERS=
Loading DAX Formula Studio...
Type [ for fields