Forum Discussion

Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
4 years ago

need a daily Alert

hi all,   there are really less options for alerts in power bi service! i have created following dax formula in PBI Desktop:   Alert = IF([price] >= [price_plan] * 0.25, 1, 0)   and put it in ...
Need Help
Pikachu-Power's avatar
Pikachu-Power
Icon for Impactful Individual rankImpactful Individual
4 years ago

Hello. Yes i could configure it. Every 24 Hours because we update data once a day.  But in the configuration it is written that Alters are only sent if your data changes. And IF([price] >= [price_plan] * 0.25, 1, 0) is every day 1 as long as [price] >= [price_plan] * 0.25. Hence no alerts. 

ibarrau's avatar
ibarrau
Icon for Super User rankSuper User
4 years ago

Oh. I see now. You may be able to cheat that changing the 1 from the TRUE response of the if with something like:

RAND() + 1

Sum a random value from 0 to 1 + 1. Then you will always get a different value like 1.23 or 1.54

That way the value will change and be higher than 0.

I hope that helps,