Forum Discussion

niko18033's avatar
niko18033
Helper I
7 years ago
Solved

Dynamic Alerts based on DAX measure

Hi All -  I'd like to set up "dynamic" alerts with a few of my dashboards that will trigger based on a dynamic threshold based on standard deviations from the mean. However, there appears to be a limitation with the current alerting capability in that it only allows the alert to be triggered on a static threshold. In my use case, the threshold will change (usually significantly) based on the most recent hourly refresh, so a static threshold would not suffice. Here's a screenshot of the alert interface I'm referring to. The '68.1' figure should instead be the "lower control limit" measure which already has been created in the underlying BI desktop file. Any ideas would be much appreciated!

 

  • Hi niko18033 ,

     

    We can create another new measure such as

     

    new = if ([target]-[standard deviations]>0,1,0)

    Then we can set the alert above1 to work around.

     

3 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support

    Hi niko18033 ,

     

    We can create another new measure such as

     

    new = if ([target]-[standard deviations]>0,1,0)

    Then we can set the alert above1 to work around.

     

    • v-frfei-msft's avatar
      v-frfei-msft
      Community Support

      Hi niko18033 ,

       

      Does that make sense? If so kindly mark my answer as a solution to close the case. Thanks in advance.