Unable to create KPI for Power BI alerting

[Anonymous]

I am currently creating PowerBI Dashboard which will imports data from an Excel file. While importing the data from Excel sheet few rows mandatory column data is missing.  I am planning to use PowerBI and Flow alerting to inform Excel users that mandatory data is missing.

My table structure is id, name, amount, email.  Here amount data is missing for a few users.

PowerBI alerting needs a number of missing rows count so that if the missing row count is greater than zero it will trigger Flow alert. I am unable to create PowerBI KPI for missing row count.

 How to Create KPI for missing row count? 

Appreciate your help.

Thanks.

[PaulPalma]

Create a measure as follows

Measure =

COUNTBLANK(Table[amount])

You should then be able to create your KPI alert based on this value.

Thanks

Paul