SLA % Measures

[Anonymous]

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.

[v-xjiin-msft · Accepted solution]

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]

My friend, is working. Thankfull.

Best Regards.