Assign a subtotal to another subtotal

[Raul]

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!

[Greg_Deckler]

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.

[Raul]

Hello @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