RemoveFilters

RemoveFilters([dimOrColumn, …]) · Context

A modifier for Calculate. Removes the named columns or whole tables (RemoveFilters(Product, Customer)) from the user-filter set and from the grouping keys of the measure’s evaluation — which is exactly what makes a %-of-total denominator a total across the removed dimensions. RemoveFilters() with no arguments removes all user filters and grouping — the grand total.

It can never touch row-level security: RLS is applied beneath the measure layer and isn’t in the removable filter set, by construction.

Example

PctOfTotalRevenue := Divide(
    [Revenue],
    Calculate([Revenue], RemoveFilters(Product, Customer))
)

Good to know

• Only meaningful inside Calculate(…) — used elsewhere it fails with SQX008.
• Inside a Fixed body, RemoveFilters lifts user filters and outer grouping but cannot collapse the Fixed grain itself.

Related

• Calculate
• KeepFilters
• Fixed
• SQX008
• Function index