% of parent row in Power BI
This tutorial describes, how to get the percentage parent row in Power BI Matrix visual.
For example here I´d like to see, what that part of Ford´s price makes Focus, Fiesta and other models.
Unfortunately in Power Bi you can´t use the Show values as – in contrary to Pivot table in Excel. So we will use DAX.
New measure will be calculated like this:
-
Percent share of models price = DIVIDE(SUM(Sheet1[Price]);CALCULATE(SUM(Sheet1[Price]);
ALL(Sheet1[Model])))
Why?
- DIVIDE – divides the total price of specific model by total price of brand
- CALCULATE – merges multiple functions together. Now it´s SUM and ALL
- ALL – disables all filters in visuals related to Model