EXPANDALL DAX Function
Retrieves a context with added detail levels along an axis compared to the current context. With an expression, returns its value in the new context, enabling navigation to the lowest level on the axis, and is the inverse of COLLAPSEALL.
Syntax
Parameter | Attributes | Description |
---|---|---|
Expression | Optional |
The expression to be evaluated in the new context. |
Axis |
An axis reference. |
Related articles
Learn more about EXPANDALL in the following articles:
-
Introducing EXPAND and COLLAPSE for visual calculations in Power BI
This article introduces the two basic visual context navigation functions: EXPAND and COLLAPSE. » Read more
Last update: Oct 3, 2024 » Contribute » Show contributors
Contributors: Alberto Ferrari, Marco Russo
Microsoft documentation: https://learn.microsoft.com/en-us/dax/expandall-function-dax