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(


  • 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

Leave a Reply

Your email address will not be published.


clear formPost comment