Forum Discussion

MichaelDoig's avatar
MichaelDoig
Icon for Advocate I rankAdvocate I
5 years ago

Anomaly detector gives impossible min expected value

Hi all,   We're enjoying the Anomaly Detector and have added the visual to several assets across our organisation. We noticed that we're seeing some cases where the expected min value is a negative...
Need Help
v-alq-msft's avatar
v-alq-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, MichaelDoig 

 

Based on your description, I assume that you want to hide the data points where the measure is a negative number.

 

You may create a measure like below.

Measure = 
IF(
    SUM('Table'[Val])>=0,
    1,0
)

 

Then you need to put the measure in the visual level filter to filter the result.

 

Best Regards

Allan

 

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

Anonymous's avatar
Anonymous
Not applicable
4 years ago

I am facing a similar issue.   Doing anamoly detection on shipped quantity.   It's not possible to have a negative shipped quantity, and I have indeed added a measure to the visual to only show >= 0 but I still get negative values in the "expected min value".    There is no way to set the min/max values in the anamoly field itself.