Check whether Incident Missed SLA or not

[Premlatapandey9]

Hello Everyone, I'm seeking guidance on how to structure the DAX formula to calculate if an incident missed its SLA based on the given criteria below. Specifically, I need to compare the incident based on the severatiy of incident and related defined SLA 

SLA is defined as below

TTA for Sev 1 is 1 day

TTA for Sev 2 is 2 days

TTA for Sev 3 is 4 day

TTM for Sev 1 is 1 day

TTM for Sev 2 is 2 days

TTM for Sev 3 is 4 day

TTR for Sev 1 is 5 day

TTR for Sev 2 is 6 days

TTR for Sev 3 is 7 day

and Data columns in data set is like below 

Incident Id	TTM (Day)	TTR(Day)	TTA(Day)	Severity	SLA Check
9848474	2	0	1	2
3474848	1	3	3	3
8374643	7	5	5	2
4847474	47	8	6	1
4747464	2	6	3	3

Please help me with the Dax query to achive this result if possible any hlep in this regard is much appreciated

Thanks and Regards

@member @help @needurgenthelp

[Anonymous · Accepted solution]

Hi @Premlatapandey9 ,

Please try to create a new column with below dax formula:

SLA Check =
VAR _sev = [Severity]
VAR _ttm = [TTM (Day)]
VAR _ttr = [TTR(Day)]
VAR _tta = [TTA(Day)]
VAR _val =
    SWITCH (
        _sev,
        1,
            IF ( _tta <= 1 && _ttm <= 1 && _ttr <= 5, "Not Miss", "Miss" ),
        2,
            IF ( _tta <= 1 && _ttm <= 2 && _ttr <= 6, "Not Miss", "Miss" ),
        3,
            IF ( _tta <= 4 && _ttm <= 4 && _ttr <= 7, "Not Miss", "Miss" )
    )
RETURN
    _val

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.