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.
writing a measure to count based on several criteria
HI all I need to write a measure to calculate SLA adherence. I have 4 collumns Closedatex - Unix time, blank until ticket closed Fixbyx - Unix time set on ticket opening, this is when the call needs to be closed to meet its SLA requirments Withinfix - set to 0 if closedatex > fixbyx, set to 1 if closedatex< fixbyx blank ticket still open Status - Number value that records the current state of the ticket (open closed on hold etc) I have a measure that calculates SLA adherence where withinfix = 1 / total number of tickets, thisisnt a true representation of what has been achieved as it assumes all calls that are open have breached their SLA. So I rejigged it to count only the closed calls, this however leaves me in a position where I am missing the tickets that hve breached their SLA requirements but because they are not closed the withinfix flag hasnt been set. I could really used some help working out how to write a measure that calculates count of tickets where withinfix = 1 / count of tickets where NOW > fixbyx and status <> "16" or "6" The other pain is the fixbyx is a unix time stamp and I dont know if it is best to convert this before comparing it to the current time or if there is another way. Hopefully this makes sense, any help will be massivley apprechiated. Thanks Ryan!!DAX SLA Calculation - Multiple Countries, different weekends and holidays
Hello experts, I have a complex scenario here, I need to calculate SLA using DAX for tickets related to different countries. I have 3 data tables- tickets data, weekly off, and Holidays. I can create/modify DATE dimension as required to acheive this. I need to calculate "Business hours to close" considering all countries have working hours from 09:00 AM to 05:30 PM. Please refer to below screenshot for sample data. If required, I can change the strcuture of Weekend table by moving DayName1 and DayName2 columns to rows instead of columns. I am able to do in Excel with the help of NETWORKDAYS.INTL and other formulaes. Any help/ suggestions would be appreciated. Thanks in advance!
