Alerts above a certain number only after certain time of day

[MP-iCONN]

I have a card in my report that will show how many employees are clocked into a work order at any given moment during the day.

I pinned that card to a Dashboard and setup a threshold of above 0 (as seen in my screenshot below).  This of course will trigger every 24 hrs once that goes above 0 which it will during the day.  My goal is to try and have it only alert me if someone is still clocked in after, for example, 5:00pm central time.   I tried with a work flow based on reccurence but it seems to just trigger it and send me the alert even though the number is zero at that time of day. 

I hope this is clear and thank you for any help.

Chad

[MP-iCONN]

Thank you for that info.  I have never used XMLA so I will have to read up on it.  I just started learning Power BI and converted 100+ reports from our old BI system to this one due to that vendor shutting down so my brain is a little fried.  Always fun learning new things.

[lbendlin]

That's not possible with the standard alerts. But you can craft your own. Schedule it to run after 5pm, run an XMLA query to check if your condition applies, trigger the alert if it does.