Data Alerts for each row

[Gazi]

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 there is a new row in the dataset?

I know it's a bit weird approach, maybe someone has a better idea?

Many thanks!

Gazi

[Anonymous]

How could we apply this at a monthly level for eg. sales at monthly level with alerts for a salersperson if the number dips below a certain threshold ?

Name    Jan    Feb   Mar

A           100    125     85

A           110    105     95

A           100      95     100

[skylar]

@Greg_Deckler 

Hi I am just wondering is that possible to set an alert and get the relevant project name?

Thanks a lot! 

[Greg_Deckler · Accepted solution]

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)

[Anonymous]

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

[Gazi]

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]

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.

[Anonymous]

Hi Greg,

do you have already a workaround regarding the data alert with data name (like the project name in this example)?

Thank you in advance.

[RemiAnthonise]

Hi Greg @Greg_Deckler , I need some help regarding these data alerts. I've also started a new topic for my issue here.

I've made a measure following your help.

Notification =
VAR myCount = COUNTROWS(FILTER(SickEmployees;([Days sick]>=2)))
RETURN IF(ISBLANK(myCount);"None";myCount)

What I think it should do: it counts all rows where 'days sick' >= 2. I get 'none' beceause it's blank. If I change the measure to >=1 it gives me 74. The sum of days sick.

What I expect / want: I want to get a notification when someone is sick for >= 17 days. So the measure should be changed to

VAR myCount = COUNTROWS(FILTER(SickEmployees;([Days sick]>=2)))
RETURN IF(ISBLANK(myCount);"None";myCount). But like I said, this gives me 'none'.

You can find the sample file here in my Dropbox.

[Gazi]

@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!  🙂