Check whether Incident Missed SLA or not

Premlatapandey9 — Fri, 25 Aug 2023 07:21:08 GMT

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

Re: Check whether Incident Missed SLA or not

Anonymous — Mon, 28 Aug 2023 02:21:21 GMT

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.

topic Check whether Incident Missed SLA or not in DAX Commands and Tips

Check whether Incident Missed SLA or not

Re: Check whether Incident Missed SLA or not