Forum Discussion
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?
Example: If i have 110 rows in SLA Column, where 80 are Within, 20 are Breached and 10 No Target. So the % FulFillment (Within) SLA is 80% above 100 rows measured (Within and Breached items). Thankfull.
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.
2 Replies
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.