Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
skandar
Regular Visitor

Calculation SLA with some data

Hello everyone. 
I'm a newbie at power bi and still learning everyday through youtube and this forum. 
I have to make a rapport to show sla, in this rapport i have to display :

sla each month  (sla achieved / sla achieved + sla breached)

sla target at 90%

number of sla achieved per month

numer of sla breached per month

 

this is a sample of what i already did but i have some problems.

the SLA calculation runs to the end of the year while i want it to stop at the current date (or latest date in the import) 

the SLA target runs to the end of the year while i want it stop at the current date (or latest date in the import)

the main problem is that in certains month, there is no sla achieved and while the formula is achieved/achieved+breached i have the result "empty" instead of 0.
I'll write all the formula i usa to show you how it looks like :

 

Display achieved and breached per month:

  1. OLA Achieved = IF('SLA(OLA)'[Stage]="Achieved", FORMAT ( [Closed at], "YYYY/mm" ))
  2. OLA Breached = IF('SLA(OLA)'[Stage]="breached", FORMAT ( [Closed at], "YYYY/mm" ))

 

Display SLA calculation :

ola calcul = 0+CALCULATE(COUNT('SLA(OLA)'[Stage]),'SLA(OLA)'[Stage]="Achieved")/(CALCULATE(COUNT('SLA(OLA)'[Stage]),'SLA(OLA)'[Stage]="Achieved")+CALCULATE(COUNT('SLA(OLA)'[Stage]),'SLA(OLA)'[Stage]="Breached"))
 
my formula to display a line at 90% between the first date and the last date is not working for the moment
skandar_0-1660138643055.png

Thank you in advance

2 REPLIES 2
amitchandak
Super User
Super User

@skandar , if you need count of ID(say) achieved 90% or more ,

 

then you need a measure like

 

countx(filter(values(Table[ID]), [ola calcul]>.9), [ID])

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

there is an exemple of my data which i work with. I don't need to set an "ID">9 because i already have this data. 

skandar_0-1660170363816.png

i need to count nb of achieved, nb of breached and display them per month. Plus of course the calculation of the SLA

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.