← Files Power BI Report CopilotARCHIVED FILE
references/dax-context.md
884 Bytes · Nov 20, 2026 · 06:46 UTC
# 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