Matrix visual: Adding column subtotals when you have 2 column hierarchies

[Maina_Keza]

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? 

[v-yinliw-msft]

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.

[Greg_Deckler]

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/n4TYhF2ARe8

Also, 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.