Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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:
Display SLA calculation :
Thank you in advance
@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])
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.
i need to count nb of achieved, nb of breached and display them per month. Plus of course the calculation of the SLA
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 31 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |