% 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]);
- 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