Matrix subtotals issue

[Anonymous]

Hi all,

I have a table with two rows and two columns:

value	currency
7.485	EUR
12.548	CNY

I created a matrix defined to have the sum of the values by currency. What I expect is 

currency	value
EUR	7.485
Total	7.485
CNY	12.548
Total	12.548

What I get is this:

Where is my error ? Maybe is it a bug ?

PS: I made this for debug, my needs are on a complex matrix 🙂

Thanks a lot

Roberto

[v-chuncz-msft]

@Anonymous ,

Drag the calculated column below to Rows as well and take a look at Using drill down with the Matrix visual.

Column =
Table1[currency]

• https://community.powerbi.com/t5/Desktop/matrix-visual-show-total-only/m-p/472465#M219588
• https://community.powerbi.com/t5/Desktop/Matrix-remove-white-space/td-p/442817

[Anonymous]

Hello @v-chuncz-msft,

thanks a lot for your answer. Sorry for the delay but i was not able to test your suggesteed solution till today.

Unfortunately this solution is not working totally, because the global totals are already in not separated sum (as picture show).

Thank you so much 🙂