REMOVEFILTERS

As a filter of CALCULATE, removes the filters on tables or columns, or all of them.

Group: Filter. Compatible with DAX.

Syntax

REMOVEFILTERS ( <table> )
REMOVEFILTERS ( <column> [, <column>] … )
REMOVEFILTERS ( )

Returns

Filter. No value of its own: it takes filters away from the CALCULATE or CALCULATETABLE it is in.

Remarks

• In CALCULATE it does what ALL does there: REMOVEFILTERS ( Products ) removes every filter on Products, REMOVEFILTERS ( Products[Product] ) only that column's, REMOVEFILTERS ( ) every filter in the model.
• Its name says what happens, which makes a measure easier to read: ALL can also be a table of rows, REMOVEFILTERS only removes.
• Use it only as a filter of CALCULATE or CALCULATETABLE. Where a table of rows is needed, use ALL.
• Conditions in the same CALCULATE still apply, whatever their order: CALCULATE ( [Liters sold], Products[Category] = "Cider", REMOVEFILTERS ( ) ) is all the cider.

Examples

Each product's share of all liters

EVALUATE
SUMMARIZECOLUMNS (
    Products[Product],
    "Liters", [Liters sold],
    "Share", DIVIDE ( [Liters sold], CALCULATE ( [Liters sold], REMOVEFILTERS ( Products ) ) )
)
ORDER BY Products[Product]

Every filter removed, then one condition

EVALUATE
CALCULATETABLE (
    ROW (
        "In Frogner", [Liters sold],
        "Everywhere", CALCULATE ( [Liters sold], REMOVEFILTERS ( ) ),
        "Cider everywhere", CALCULATE ( [Liters sold], Products[Category] = "Cider", REMOVEFILTERS ( ) )
    ),
    Places[District] = "Frogner"
)

Related functions

ALL, ALLEXCEPT, ALLSELECTED, CALCULATE, KEEPFILTERS.

Last updated 3 November 2026 · OpenBI Studio 0.3.74