Exclude

Context

Exclude(dim…, expr)

View-relative LOD: the expression evaluates at (the chart’s grouping minus the listed dimensions) — a coarser grain — and the value replicates across the excluded dimension’s rows. The classic use is a percent-of-subtotal denominator that ignores one grouping level while following the rest of the view.

When to use it

% within group: share of each region inside its month — Divide([Revenue], [MonthTotal]) where the denominator excludes Region but follows every other axis.
Subtotal rows/columns that track the view as the viewer regroups it.

Example

// each region row shows the month total across ALL regions
MonthTotal := Exclude(Sales.Region, [Revenue])

PctOfMonth := Divide([Revenue], [MonthTotal])

Good to know

Excluding every grouping level is legal — the value degrades to the grand total within filters (same as RemoveFilters() on the grouping, but view-relative).