Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Calculate difference of % between two rows

Hello Community,   I tried to find through the forums a solution to my problem. So the "recovery Service Level" is a created measure that calculate the Lines Shipped cumulative divided by the Sum o...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous 

Create measures

Recovery Service Level% =
VAR total = 26303
RETURN
    CALCULATE (
        SUM ( 'Table'[Lines Shipped] ),
        FILTER (
            ALLSELECTED ( 'Table' ),
            'Table'[Days Late]
                <= MAX ( 'Table'[Days Late] )
        )
    ) / total

added =
VAR total = 26303
RETURN
    IF (
        MAX ( [Days Late] ) <> 0,
        CALCULATE (
            SUM ( 'Table'[Lines Shipped] ),
            FILTER (
                ALLSELECTED ( 'Table' ),
                'Table'[Days Late]
                    = MAX ( 'Table'[Days Late] )
            )
        ) / total
    )

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you very much Maggie, it seems to work indeed. What if i wanted a dynamic calculation that would change the amount of lines Shipped ? Dynamic with the slicer i want to apply?

     

    Best regards,

     

    Marc