Is there any way to show/hide a subtotal in a matrix, controlling by a measure?

[NatachaPN]

Hi! my user wants me to show a matrix with data that have different levels of hierarchy. She wants something like this (note the "Total" that summarize Label 3C1+Label 3C2+Label 3C3) 

I can't hide the subtotal for those groups of data wich this level is blank():

Any suggestion? Tnk!

[v-zhenbw-msft · Accepted solution]

Hi @NatachaPN ,

We can create two measures to meet your requirement.

Measure = 
var _total = IF(MAX('Table'[OC])="",0,1)
return
IF(ISFILTERED('Table'[PC]),0,1)+_total

Total = 
IF(
    [Measure]=1,
    CALCULATE(SUM('Table'[Quantity]),FILTER('Table','Table'[OC]<>"")),
    SUM('Table'[Quantity]))

If it doesn’t meet your requirement, could you please show the exact expected result based on the table that you have shared?

Best regards,

Community Support Team _ zhenbw

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

BTW, pbix as attached.

[lbendlin]

Here's a pretty popular approach

https://community.powerbi.com/t5/Community-Blog/Creating-a-custom-or-hybrid-matrix-in-PowerBI/ba-p/1354591