Forum Discussion
Creating Row Measures in a Matrix Table
Anonymous - What you want is absolutely possible. What you need is a disconnected table for your row headers. Then create a measure that returns the correct calculation based upon your row. So your disconnected table would be:
Column
A
B
C
Total
A % Total
B % Total
C % Total
See my Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Anonymous - What you want is absolutely possible. What you need is a disconnected table for your row headers. Then create a measure that returns the correct calculation based upon your row. So your disconnected table would be:
Column
A
B
C
Total
A % Total
B % Total
C % Total
See my Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick/ba-p/279563
Thanks Greg. I will try that and see if I can get it to work.
Thank you for the suggestion and the link to your Disconnected table Trick. It worked!!!!