Looking for some help on the formula below.
My understanding is that the formula would evaluate each condition to check if the result was “TRUE” and then return a “Fail” if any of the conditions resulted in “FALSE”.
The below is what is supposed to happen:
(1) SLA E2HR ORIGINAL =
SELECTEDVALUE ( ‘MTSE (Completed)’[Maintenance Type] ) = “Emergency 2 Hr”, //Check to see if it Maintenance Type is Emergency 2 HR
SELECTEDVALUE ( ‘MTSE (Completed)’[Is Working Day] ) = “Workday” //Check to see if it is a Working and not a Non Working Day
[Completed Date] <= [Due Date], //Check to see if the works are completed before the Due Date
[Completed Time] <= [Emergency 2HR Time Target] //Check to see if the works are completed before the Due Timeframe
[Admin Date] <= [Next Working Day], //Check to see if the works have been updated on the system before the next working day
[Admin Time] <= [Target Time] //Check to see if the works have been updated on the system before the next working day Target Time
"Fail" //If non of the above criteria match then this Fails the SLA
This Formula is providing mixed results and im not sure where or why its going wrong, ive attached some screenshots as to the results of what is happening with the formula.
And you will see that it is “Passing” on Weekends and Passing when the Maintenance Type is not Emergency 2HR.
Any help, guidance would be greatly appreciated.
PS - pretty new to PBI & DAX so any help, guidance would be greatly appreciated.
Thanks in Advance