Calculate Row Total in Matrix

[Anonymous]

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.

[PC2790 · Accepted solution]

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#M876051

https://exceleratorbi.com.au/building-a-matrix-with-asymmetrical-columns-and-rows-in-power-bi/

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

https://community.powerbi.com/t5/Desktop/Total-By-Category-In-A-Matrix/m-p/2477422#M882732