Forum Discussion
Matrix subtotals issue
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
2 Replies
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
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 :)
