cancel
Showing results for
Did you mean:
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.

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

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

1 ACCEPTED SOLUTION
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
2 REPLIES 2
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
Helper I

Thank you @DimaMD

It worked 😉

Announcements

#### 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.

#### 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!

#### Business Application LATAM Summit 2023

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

#### 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