Help with a SLA measure pls

[mshamsiev]

Hi all,

I've got a SLA table with several Assignment Groups and a Stage column with either Achieved or Breached. 

I'm trying to work out the % achieved based on the Stage column for each assignment group and create a dial that changes based on the selection. Anyone know how I can achieve this? Thanks in advance! 

 

-Mike

[DoubleJ · Accepted solution]

Hi

This approach might help. Let's say we have this SLA table:


Group1: 4 out of 5 have stage "Achieved"
Group2: 1 out of 3 has stage "Achieved"

Create this measure

SuccessRate = 
CALCULATE(
	COUNTA(SLA[Stage]),
           SLA[Stage] ="Achieved") / 
	   CALCULATE(COUNTA(SLA[Stage]))

Result:

Hope this helps!

JJ

[mshamsiev]

Hey @DoubleJ,

You're a life saver! Thanks for the help mate 🙂 

-Mike