Creating a Measure for time values

[Alta88]

We keep metrics on our daily calls and I'm looking for a way to flag and conditional format calls with a Speed-to-answer (STA) time that exceeds 15 seconds. How would I do this in Dax? 

[Alta88]

Thank you, Kaviraj11! Looks like the system is flagging an error because I have a discrepancy in the data type (text vs. date) and the formula.

[Kaviraj11 · Accepted solution]

Ok, just make sure to format it to date and then it should work.

[Kaviraj11]

Firstly, you can create a calculated column:

Flag = SWITCH(TRUE(),'Table'[Time]>TIME(0,0,15),"Yes","No")

And use the above column in conditional format 'Rules' and in Rules if value is = Yes.