Creating Row Measures in a Matrix Table

[Anonymous]

Hello,

I am new to PowerBi and need some help with adding row measures to a Matrix Table so it looks something like this:

	Jun	Jul	Aug
A	25	10	25
B	75	10	25
C	100	50	25
Total	200	70	75
A % Total	13%	14%	33%
B % Total	38%	14%	33%
C % Total	50%	71%	33%

I was able to get the table to show the bold items but cannot fin a way to add the measures into the table so that filters will apply as well. My data set looks something like this:

Product	Month	Category	Qty
A	Jun	Units	25
B	Jun	Units	75
C	Jun	Units	100
A	Jul	Units	10
B	Jul	Units	10
C	Jul	Units	50
A	Jul	Units	25
B	Jul	Units	25
C	Jul	Units	25

Any assistance you can provide is appreciated.

[Greg_Deckler · Accepted solution]

@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]

Thank you for the suggestion and the link to your Disconnected table Trick. It worked!!!!

[Anonymous]

Thanks Greg. I will try that and see if I can get it to work.

[Fowmy]

@Anonymous 

I am not sure if it's possible but the closest I can get is using the "Show on Rows" option under the Values section of the Matrix. 

________________________

Did I answer your question? Mark this post as a solution, this will help others!.

Click on the Thumbs-Up icon on the right if you like this reply 🙂

YouTube, LinkedIn

[amitchandak]

@Anonymous , the format is not possible.