Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

SLA % Measures

Hi all   I've got a SLA column with "Breached", "Within" and "No Target". I need to work out the % "Within" based on the SLA column ("Within" and "Breached") . Anyone know how I can achieve this? ...
Need Help
  • v-xjiin-msft's avatar
    v-xjiin-msft
    8 years ago

    Hi Anonymous,

     

    To achieve your requirement, you can try a measure with following expression:

     

    SLA % =
CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] = "Breached" ) )
    / CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] <> "No Target" ) )

     

    Thanks,
    Xi Jin.

v-xjiin-msft's avatar
v-xjiin-msft
Icon for Solution Sage rankSolution Sage
8 years ago

Hi Anonymous,

 

To achieve your requirement, you can try a measure with following expression:

 

SLA % =
CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] = "Breached" ) )
    / CALCULATE ( COUNT ( SLA[SLA] ), FILTER ( SLA, SLA[SLA] <> "No Target" ) )

 

Thanks,
Xi Jin.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    My friend, is working. Thankfull.

     

    Best Regards.