Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to:
Calculated column
Calculated table
Measure
Visual calculation
Retrieves a context at the highest level compared to the current context. If an expression is provided, returns its value in the new context, allowing for navigation in hierarchies and calculation at the highest level.
The syntax that performs both navigation and calculation.
COLLAPSEALL ( <expression>, <axis> )
The syntax that performs navigation only.
COLLAPSEALL ( <axis> )
Term | Definition |
---|---|
expression |
The expression to be evaluated in the new context. |
axis |
An axis reference. |
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 highest level. For the version that performs navigation only, the function modifies the evaluation context by navigating to the highest level.
Given a table that summarizes the total sales for a hierarchy with levels for total, year, quarter and month, the following DAX calculation fetches the value of [SalesAmount] at the highest level, total.
TotalValue = COLLAPSEALL([SalesAmount], ROWS)
The screenshot below shows the matrix with the visual calculation.
Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!