The DAX dictionary
The DAX functions and concepts that cause most wrong numbers and slow reports — each with syntax, worked examples, performance notes and the mistakes to avoid.
DAX SUM Function
SUM adds all numbers in a column. It automatically respects the current filter context set by slicers, rows, columns, and visual filters.
Read Context & FilteringDAX CALCULATE Function
CALCULATE evaluates an expression within a modified filter context. It is the only function in DAX that can create, modify, or override existing filter context.
Read Context & FilteringDAX FILTER Function
FILTER iterates row-by-row over a table and returns a new virtual table containing only rows where the boolean expression is TRUE.
Read IteratorsDAX SUMX Function
SUMX iterates over a table, creates a row context for each individual row, computes an expression, and sums the results.
Read IteratorsDAX AVERAGEX Function
AVERAGEX iterates over a table, evaluates an expression for each row, and computes the arithmetic mean of the resulting values.
Read Context & FilteringDAX SELECTEDVALUE Function
SELECTEDVALUE returns the value of a column when there is only one distinct value in the current filter context; otherwise returns an alternate result.
Read AdvancedDAX SWITCH Function
SWITCH evaluates an expression against a series of values and returns the corresponding result. The SWITCH(TRUE(), ...) pattern enables powerful multi-condition branching.
Read AdvancedDAX RANKX Function
RANKX computes the rank of an expression across a given table or set of dimension keys in the current visual context.
Read Time IntelligenceDAX Time Intelligence
Time Intelligence functions simplify temporal calculations: Year-to-Date, Month-over-Month, and moving averages.
Read Context & FilteringUnderstanding Filter Context
Filter Context is the cumulative set of filters applied to the semantic model by slicers, visual axes, filters pane, and cross-highlighting.
Read Context & FilteringUnderstanding Row Context
Row Context refers to the awareness of the current row being scanned. It exists automatically in calculated columns and is created by iterators like SUMX and FILTER.
Read AdvancedDAX Context Transition
When CALCULATE is evaluated inside an active row context, it converts the values of all columns in the current row into an equivalent filter context.
Read