cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Newbie22
Helper I
Helper 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
Super User
Super User

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

View solution in original post

2 REPLIES 2
DimaMD
Super User
Super User

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

Thank you @DimaMD 

 

It worked 😉

Helpful resources

Announcements
Carousel_PBI_Wave1

2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.

Top Solution Authors
Top Kudoed Authors