How to get Subtotal Percentage

[AmirFirdaus9509]

Hi , I would like to request an advice on how to fetch a subtotal percentage 

I have use Decomposition Tree Graph to show breakdown of a Total amount of Data and i would like to create a breakdown based on month and breakdown percentage of response status as shown in the image. The image shown is a breakdown , I would like the graph to calculate percentage 46/163 instead of 46/617 

How can i get a Subtotal percentage of January , February and March

Thank you for the help

[amitchandak]

@AmirFirdaus9509 , if possible try a measure like

divide([Measure], calculate([meausre], removefilters(Table[Response Status])))

[AmirFirdaus9509]

Hi @amitchandak ,
I have tried to recreate based on your measure through my knowledge
as am i not experienced with PBI , is this correct?

Thank you again

[v-lionel-msft · Accepted solution]

Hi @AmirFirdaus9509 ,

Please refer to my .pbix file.

Measure = 
IF(
    HASONEFILTER(Sheet14[C1]) = TRUE(),
    IF(
        HASONEFILTER(Sheet14[C2]) = FALSE(),
        DIVIDE(
            SUMX( FILTER( ALL(Sheet14), [C1] = MAX([C1]) ), [Value] ),
            SUMX( ALL(Sheet14), [Value])
        ),
        DIVIDE(
            SUMX( FILTER( ALL(Sheet14), [C1] = MAX([C1]) && [C2] = MAX([C2]) ), [Value] ),
            SUMX( FILTER( ALL(Sheet14), [C1] = MAX([C1]) ), [Value] )
        )
    ),
    1
)

Best regards,
Lionel Chen

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

[amitchandak]

@AmirFirdaus9509 , "values" which is giving DPMonth, does not seem correct to me.

Can you share a sample pbix after removing sensitive data.