← Files Power BI Report CopilotARCHIVED FILE

references/dax-context.md

884 Bytes · Nov 20, 2026 · 06:46 UTC

↓ Download file

See the change to this file →

# DAX filter context and defensible totals
A measure is evaluated in the visual's filter context. Understand relationships, slicers, page/report filters, nested CALCULATE, row context, iterators and context transition. The correct total may not be the sum or mean of visual row percentages.
For `Margin % = DIVIDE([Margin],[Revenue])`, group and total are generally ratios of aggregations if that is the business definition. Don't replace with AVERAGEX unless the requested metric is an average of per-group rates. Debug base numerator/denominator measures, DISTINCTCOUNT of keys and a small `SUMMARIZECOLUMNS` test where tools permit.
`ALL`, `REMOVEFILTERS`, `ALLSELECTED`, `KEEPFILTERS`, inactive relationships and USERELATIONSHIP change semantics. Only add with a stated business rule. Label hypothetical output vs executed output.
Official: https://learn.microsoft.com/en-us/dax/

SHA-256: 57081253e5d3727f83d0dbcbcc2c5f093a8ffc613d2cc67ed2bae317b25e3ef9