Subtotal Percentage on Row matrix

[joannageorge]

Hi guys

I am trying to create a matrix on power bi, and it should appear like this. How do i create a High Mix, Mid Mix, Low Mix on power bi? 

On the rows, I have store names, and on columns I have Product names by Quarter and Year to date. 

The % should be by product for each store, and by the high, mid, low. 

Appreciate any help on this. 

[lbendlin]

Here's a solution but it will be a lot of work.

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1...

You can consider Calculation Groups.  You can also consider talking your business users down to simplifying the requirement.

Worst case, tell them to stick with Excel for this one.