One thought, but I have not tried this yet:
- You create a card visual that shows the Variance measure on a report page. You need this to trigger the emails. It can even been hidden and only be accessible through a bookmark if there is no other use for it in the report.
- You put the card visual on a dashboard so you can set up the alarms.
- You set up row level security so that each user sees her individual Variance value. You can use your email list to make this happen programmatically.
- You create a Microsoft 365 security group from the list of email addresses that you use as the receiver for the email alerts.
Now step 4. is where I’d be curious to see whether this results in individual emails based on the individual value or everyone receiving the same email at the same time which could be a security issue.
If it doesn’t work, then it should work if every user sets up her individual alert with her individual email address.
Let us know how it worked out for you.