EXPANDALL

Updated on

EXPANDALL is a DAX function that retrieves a context with all added detail levels along an axis compared to the current context.

Syntax

EXPANDALL(
   Expression,
   Axis
)
Argument Properties Description
Expression Optional The expression to be evaluated in the new context.
Axis An axis reference.

Return Values

For the version that performs both navigation and calculation, the function returns the value of the expression in the new context after navigating to the lowest level of the hierarchy. For the version that performs navigation only, the function modifies the evaluation context by navigating to the lowest level of the hierarchy.

Remarks

  • This function can be used only in visual calculations.
  • The navigation-only version of the function can be used inside the CALCULATE function.
  • The levels of the hierarchy are determined by all columns in each axis referenced by the axis reference.
  • Often, there are multiple descendent cells at a lower level; therefore, some form of aggregation is required for the expression argument.

Example

Given a table that summarizes the total sales for a hierarchy with levels for total, year, quarter and month, the following DAX calculation calculates the maximum value of [SalesAmount] at the lowest level, [Month].

MaxOfLeafLevel = EXPANDALL(MAX([SalesAmount]), ROWS)

The screenshot below shows the matrix with the visual calculation.

DAX visual calculation

Other functions related to EXPANDALL are:

Contribute » | Contributors: Rick de Groot

2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy