DAX function
REMOVEFILTERS — DAX function reference
Clear filters (modern ALL).
Syntax
dax
REMOVEFILTERS([<table> | <column1> [, <column2>, …]])
Examples
dax
CALCULATE(SUM(Sales[Amount]), REMOVEFILTERS(Sales[Region]))
→ A number
dax
CALCULATE(SUM(Sales[Amount]), REMOVEFILTERS(Product))
→ Total ignoring all Product-table filters, keeping Date/Region
REMOVEFILTERS() with no arguments clears the entire filter context, the same as ALL() with no table.
dax
DIVIDE([Sales], CALCULATE([Sales], REMOVEFILTERS()))
→ Percent of the grand total, using the modern no-arg form
Common mistakes & gotchas
- REMOVEFILTERS behaves like ALL as a CALCULATE filter argument, but unlike ALL it can't be used as a standalone table expression elsewhere — e.g., COUNTROWS(REMOVEFILTERS(Product)) isn't valid the way COUNTROWS(ALL(Product)) is.
- It was introduced to make intent explicit, so prefer it over ALL in new CALCULATE filter arguments for readability, but expect older models to still use ALL everywhere.
Related DAX functions
From Filter context