power bi alert email

Hi arkiboys2 

Yes you can achieve this using measure.

Follow the below steps:

> You can use a measure to count rows where error_message is not blank. This measure will serve as a basis for the alert.

ErrorCount = COUNTAX(FILTER('YourTable', NOT(ISBLANK('YourTable'[error_message]))), 1)

This ErrorCount measure will return a count of rows where error_message is populated.

> Add a Card visualization in your report and use the ErrorCount measure.
> This card will display the count of error messages each day.

> Publish your report to the Power BI Service.
> In the service, go to your report, locate the card visualization with the ErrorCount measure, and click on the ellipsis (...) menu.
> Select Manage Alerts and set up a new alert:
> Set the alert to trigger when the ErrorCount is greater than 0.
> Customize the frequency and conditions of the alert (e.g., once a day or every time data refreshes).
> Enable email notifications for this alert, so you receive an email whenever the ErrorCount is greater than 0.