Cheat Sheets/Power BI/REMOVEFILTERS
DAX function

REMOVEFILTERSDAX 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

Related DAX functions

From Filter context

← Back to the Power BI (DAX) cheat sheet