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