Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
@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]
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 🙂
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
80 | |
67 | |
63 |
User | Count |
---|---|
147 | |
110 | |
108 | |
85 | |
64 |