Get Expected Value from Find anomalies through DAX

[adeg33]

Hello All,

I am trying to get this expected value generated from enabling Find anomalies in a visual through DAX.
I know its basing from the trend line/line regression but I cant seem to find the value or just a value close enough in the Expected Value using DAX. Any help is much appreciated, Thank you !

[Anonymous · Accepted solution]

Hi  @adeg33 ,

Adding Anomaly detection automatically enriches the chart with anomalies and a range of expected values. The expected minimum/maximum values are controlled by the sensitivity (0 - 100%). The higher the sensitivity, the more anomalies there are and the narrower the confidence interval (expected min/max values).

Excepted Value should be calculated according to the Anomaly Detector algorithm, you can check the explanation of the algorithm given in the official documentation.

Check out this technical blog for more details about the Anomaly Detector algorithm.

This is relevant information about Anomaly detection:

Share your thoughts on the new Anomaly detection f... - Page 4 - Microsoft Fabric Community

Anomaly detection tutorial - Power BI | Microsoft Learn

Anomaly detection (preview) | Microsoft Power BI Blog | Microsoft Power BI

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.