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

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)
  • Gazi's avatar
    Gazi
    Frequent Visitor
    8 years ago

    Thank you Greg_Deckler!

     

    It actually worked! :)

    But is there any way to see relevant row's data? i mean which row triggered it (it contains project names)

    • 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!  :)

         

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Not the solution I would have thought of at all, but I have to say this would do the trick nicely.  Thanks!