Forum Discussion

AmirFirdaus9509's avatar
AmirFirdaus9509
New Member
5 years ago
Solved

How to get Subtotal Percentage

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...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    5 years ago

    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's avatar
amitchandak
Super User
5 years ago

AmirFirdaus9509 , if possible try a measure like

 

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

 

AmirFirdaus9509's avatar
AmirFirdaus9509
New Member
5 years ago

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

 

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

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

    Can you share a sample pbix after removing sensitive data.

     

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    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.