Forum Discussion
Matrix visual: Adding column subtotals when you have 2 column hierarchies
Hello,
I have a matrix visual with 2 fields in the column section one called "Period" and the other "Agreement". I am trying to add a column subtotal.
When I add one, It does show the column sub total on the column with the highest hierarchy (in this case Period), but when I click on the drill on columns option, and expand down to the column with the lowest hierarchy (in this case Agreement), then the column subtotals don't show!
I tried playing with the option to set column subtotals per level, but it didn't work. I tried both on the desktop and online service.
Can anyone help me with this?
2 Replies
- Greg_Deckler
Community Champion
First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e
This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907
Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8Also, this may help as well: Matrix Measure Total Triple Threat Rock & Roll - Microsoft Power BI Community
Finally, if none of that helps: Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2. 
v-yinliw-msftCommunity Support
Hi Maina_Keza ,
I create a sample data table to test.
Could you please tell me what is your logic for calculating values by measure?
Here is my PBIX file.
Best Regards,
Community Support Team _Yinliw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
