Splits a measure over multiple dimensions in an order you choose, as one of Power BI's AI visuals. Its AI splits can recommend which dimension to explore next to find the highest or lowest result.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Decomposition tree in context, with comparison tables and the common traps.
Terms in this definition
- Measure
A figure like total revenue, worked out by aggregating fact table data wherever dimensions intersect within a semantic model.
- OVER
Gives a T-SQL window function its window: PARTITION BY, ORDER BY and, if wanted, a ROWS or RANGE frame. Rankings and running totals can then be worked out while every row is kept.
- Power BI
Microsoft's analytics and reporting service. It reaches data held on-premises through the on-premises data gateway.
- AI splits
A decomposition tree mode, shown by a light-bulb icon, in which Power BI itself picks the field to expand next, looking for high or low values in absolute or relative terms. It is unavailable in Power BI Report Server, Azure Analysis Services and publish-to-web reports.
- NEXT
Restricted to visual calculations, this DAX function reads the value one step further along an axis of the visual matrix; writing OFFSET with 1 gives the same result.