Forum Discussion

Gazi's avatar
Gazi
Frequent Visitor
8 years ago
Solved

Data Alerts for each row

Hi everyone!     I need to create an alert for each row in my dataset, whenever any of them goes below 5. Currently i have 85 rows, i could create 85 visuals for each, but how to handle when ther...
Need Help
  • Greg_Deckler's avatar
    Greg_Deckler
    8 years ago

    Create a measure like this and set a notification for > 0

     

    BelowFive = 
VAR myCount = COUNTROWS(FILTER(Table,[Column]<5)
RETURN IF(ISBLANK(myCount),0,myCount)
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
8 years ago

I believe that you can only set alerts on numeric data so it wouldn't work to concatenate all the project names rows together which was my first thought. Glad it worked though!! If I come up with something I'll let you know.

Gazi's avatar
Gazi
Frequent Visitor
8 years ago

Greg_Deckler Yeah I am also trying to think about any possible way to show the relevant project names, which triger an alert, that would be an amazing workaround the current limitation of the Data Alert in PowerBI.

 

Thanks a lot!  :)