Subtotals in drill-down

[floressdiego]

Hello,

Sorry for the text in portuguese. I am trying to make it so the subtotal "FATURAMENTO LÍQUIDO" doesn't get drilled down. As you can see by the collors, this subtotal is doubling everything above him (as it should as calculation, but not in the visual bit) and I don't know how to show only the total and not everything that composes it.

Here is the measure I'm using:

Realizado = 

    SWITCH(TRUE(),
    SELECTEDVALUE('Máscara'[Subtotal?])=0,[Total Realizado],
    SELECTEDVALUE('Máscara'[Subtotal?])=1, CALCULATE([Total Realizado],
        ALL('Máscara'[Conta Contábil]),
        'Máscara'[Cod Formato] <= VALUES('Máscara'[Cod Formato])
    ),BLANK()
)

As you can see, if it is a subtotal sum everything above, but what I would like to do is only show the total. If i click on drill-down it should appear the '-' sign without another line being added, only the total beside it.

The files are below. Didn't add "Orçado" as it is not important.

https://1drv.ms/u/s!Au9GnH7ZLFaWiFFCbLAebSfarK3s?e=NwpCh8 

Thanks for any help.

[v-yiruan-msft]

Hi @floressdiego ,

Please try to update the formula of measure as below and check whether it can get the correct result:

Realizado = 

    SWITCH(TRUE(),
    SELECTEDVALUE('Máscara'[Subtotal?])=0,[Total Realizado],
    SELECTEDVALUE('Máscara'[Subtotal?])=1, CALCULATE([Total Realizado],
       FILTER(ALL('Máscara'[Cod Formato]),
        'Máscara'[Cod Formato] <= VALUES('Máscara'[Cod Formato]))
    ),BLANK()
)

Best Regards

[floressdiego]

Thank you for your reply, but with this solution as soon as I take the "Orçado" out of the Values it doesn't show the subtotals anymore. As in another page I want to be able to use only "Realizado". If you have any other solutions I would apreciate it 🙂