Moves a calculation up one level of the axis hierarchy in a visual, which is how you'd get a value as a share of its parent. This DAX function works in visual calculations and nowhere else.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains COLLAPSE in context, with comparison tables and the common traps.
Terms in this definition
- Hierarchy
Lets report users drill up and down through totals by stacking a dimension's levels in order, for example region, then city, then address, in a semantic model.
- Get
Key Vault permission on secrets that allows a single secret to be read; App Service Key Vault references need nothing beyond it.
- Share
In OpenSharing, the container you fill with tables, views, volumes, models and notebooks for recipients. You need
CREATE SHAREon the metastore to make one; add a schema and all its assets, including later ones, go with history. - DAX
Short for Data Analysis Expressions, the formula language you write measures, calculated columns and row-level security rules in, within tabular semantic models in Power BI, Excel Power Pivot or Analysis Services.
Related terms
- Window function
A function evaluated OVER a window defined by PARTITION BY, ORDER BY and optionally a frame; unlike GROUP BY aggregation it doesn't collapse rows, but adds to each one a value worked out from its related rows. Examples are RANK, ROW_NUMBER, LAG and running totals.