Hi all

I am looking at Outliers measures based on “last year” results, for Sales and Profit Margin LY only.

For some really odd reason I get non-outliers when actually the Sales and Profit Margin LY is actually an Outlier.

Example below Non-Outliers are actually Outliers.

Brandon Diaz, her Sales LY and Profit LY is actually above my threshold parameter.

So really puzzled why it is saying “Non-Outlier”.

Same, for Outliers. shows Outliers where they are actually Non-Outliers.

’

06.Testing.Last Year.pbix (1.6 MB)