Forum Discussion

kfschaefer's avatar
kfschaefer
Helper IV
8 years ago
Solved

help with Calculation

Need  help with modifying the following Measure Calculation. Compliance%Measure = CALCULATE(1 - ((SUM([OnboardedNo]) - SUM([CompliantNo]))) / SUM([Services]), ALL(IcM[Service Usage]))     Sum of ...
Need Help
  • v-jiascu-msft's avatar
    v-jiascu-msft
    8 years ago

    Hi Karen,

     

    Try this formula, please.

    Compliance%Measure =
VAR onboardedNo =
    CALCULATE (
        SUM ( [OnboardedNo] ),
        table1[OnboardedNo] = 1,
        table1[exception] = "InScope"
    )
VAR compliantNo =
    CALCULATE (
        SUM ( [CompliantNo] ),
        table1[CompliantNo] = 1,
        table1[exception] = "InScope"
    )
VAR total =
    CALCULATE ( SUM ( [Services] ), table1[exception] = "InScope" )
RETURN
    CALCULATE (
        1
            - ( onboardedNo - compliantNo )
            / total,
        ALL ( IcM[Service Usage] )
    )

    Best Regards,

    Dale

v-jiascu-msft's avatar
v-jiascu-msft
Microsoft Employee
8 years ago

Hi Karen,

 

Try this formula, please.

Compliance%Measure =
VAR onboardedNo =
    CALCULATE (
        SUM ( [OnboardedNo] ),
        table1[OnboardedNo] = 1,
        table1[exception] = "InScope"
    )
VAR compliantNo =
    CALCULATE (
        SUM ( [CompliantNo] ),
        table1[CompliantNo] = 1,
        table1[exception] = "InScope"
    )
VAR total =
    CALCULATE ( SUM ( [Services] ), table1[exception] = "InScope" )
RETURN
    CALCULATE (
        1
            - ( onboardedNo - compliantNo )
            / total,
        ALL ( IcM[Service Usage] )
    )

Best Regards,

Dale