Forum Discussion
Calculate Row Total in Matrix
Hi Everyone,
I have below sample Matrix table, that need your helpful advice how can create following information from various row subtotal figures: -
Row 51 (Gross Profit = 40 Turnover + 50 Cost of Sale),
Row 53 (Gross Profit Margin = 51 Gross Porfit / 40 Turnover), etc...
Thank You.
Hey Anonymous ,
Looks like you are after hybrid matrix.
See if any of the below links comes handy.
https://community.powerbi.com/t5/Desktop/Calculate-field-in-row-header/m-p/2453000#M876051https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/
https://community.powerbi.com/t5/Desktop/Total-By-Category-In-A-Matrix/m-p/2477422#M882732
1 Reply
PC2790Community Champion
Hey Anonymous ,
Looks like you are after hybrid matrix.
See if any of the below links comes handy.
https://community.powerbi.com/t5/Desktop/Calculate-field-in-row-header/m-p/2453000#M876051https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/
https://community.powerbi.com/t5/Desktop/Total-By-Category-In-A-Matrix/m-p/2477422#M882732