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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Newbie22
Resolver I
Resolver I

Help Needed: DAX Measure to determine if SLA reached the target or not.

Hi Everyone,

 

I'd like to ask for your help. I have data with different targets per SLA. Minimum column is also target but it's the minimum % an SLA must have.

Newbie22_2-1663764997906.png

I created a measure that I will use to create an icon (using conditional format) to determine if the SLA Summary results met the target or not. 

 

_ConditionSLATarget =
MAXX('Monthly Summary',
IF('Monthly Summary'[_SLA Summary Results] >= 'Monthly Summary'[Target],1,
IF('Monthly Summary'[_SLA Summary Results] >= 'Monthly Summary'[Minimum],0,
IF('Monthly Summary'[_SLA Summary Results] < 'Monthly Summary'[Minimum],-1))))
-----------------------------------------------------------------------------------------------------
 
My Table is: 'Monthly Summary'
SLA measure is _SLA Summary Results 
DAX Formula for _SLA Summary Results below:
_SLA Summary Results = SUM('Monthly Summary'[Met])/SUM('Monthly Summary'[Volume])
 
However, there's something strange when I put it in a table. If you notice, DAT 1 SLA should be "-1" with a downward arrow because SLA Summary result of 85.32% did not meet the minimum target of 96%
 
I don't know what went wrong so I'd like to ask for your expertise on this matter. Let me know if you need additional info. Thank you

 

Newbie22_0-1663764718481.png

 

 

Here's a screenshot of my conditional format for the icons in case you need.

 

Newbie22_1-1663764718825.png

 

 

 

1 ACCEPTED SOLUTION
DimaMD
Solution Sage
Solution Sage

Hi @Newbie22  Try it

_ConditionSLATarget = 
SWITCH(
    TRUE(),
[_SLA Summary Results] >= [Target],1,
[_SLA Summary Results] >= [_Minimum],0,
[_SLA Summary Results] < [_Minimum],-1) 

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

View solution in original post

2 REPLIES 2
DimaMD
Solution Sage
Solution Sage

Hi @Newbie22  Try it

_ConditionSLATarget = 
SWITCH(
    TRUE(),
[_SLA Summary Results] >= [Target],1,
[_SLA Summary Results] >= [_Minimum],0,
[_SLA Summary Results] < [_Minimum],-1) 

__________________________________________

Thank you for your like and decision

__________________________________________

Greetings from Ukraine

To help me grow PayPal: embirddima@gmail.com

Thank you @DimaMD 

 

It worked 😉

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.