Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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/Desktop/Total-By-Category-In-A-Matrix/m-p/2477422#M882732
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/Desktop/Total-By-Category-In-A-Matrix/m-p/2477422#M882732
User | Count |
---|---|
91 | |
77 | |
71 | |
65 | |
58 |
User | Count |
---|---|
103 | |
94 | |
75 | |
61 | |
58 |