% 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