Forum Discussion
Raul
Post Patron
Post PatronAssign a subtotal to another subtotal
Hello,
I have this table:
| Area | Col | Amount |
| LAB | Office | 10 |
| LAB | Office | 20 |
| LAB | C1 | 5 |
| JUR | Office | 30 |
| JUR | C1 | 20 |
| JUR | C1 | 15 |
| JUR | C2 | 10 |
and this matrix visualization:
| Amount | |
| LAB | 35 |
| Office | 30 |
| C1 | 5 |
| JUR | 75 |
| Office | 30 |
| C1 | 35 |
| C2 | 10 |
| Total | 110 |
And I want to distribute the value of the amount in this way:
| Amount | |
| LAB | 35 |
| C1 | 5 |
| JUR | 75 |
| C1 | 35 |
| C2 | 10 |
| Total | 110 |
That is, don't show Office value of Col column and totalize his value with de subtotal of the Area column. It's possible? How should it be done?
Thank you!
2 Replies
- Greg_Deckler
Community Champion
So, take a look at this: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376
What you would want is to make sure that you use ALL when calculating the total.
RaulHello Greg_Deckler,
I tried to apply what you say about ALL in the totals but I still do not get the desired value. Can you detail your answer a little more?
Thank you
