Filter with ABS partially works

[shakavi]

Hi Community,

I have created a Parameter in order to filter my visuals (from 0% to 100%)

I have created a formula to compare the percentages (positives and negatives) with the parameter

Filter Delta Nor = IF(ABS('Measures table'[Delta Nor])>'Boundary Delta Nor 3'[Boundary Delta Nor 3 Value],1,0)

When I apply the filter in the visual to show only the "1" it is also showing me a few 0, and if I show the "0" it shows a few 1 as well but not all. If I remove the ABS showing only the positive it works, but I need to show negatives and positives.

Thanks!

[tamerj1 · Accepted solution]

Hi @shakavi 
Please try

Filter Delta Nor =
IF ( ABS ( DIVIDE ( [Delta Nor], [Boundary Delta Nor 3 Value] ) ) > 1, 1, 0 )

[shakavi]

Yeap, it works as well. Sorry, I did not realize that in the matrix I had groups, so expanding the rows there were a few 1 in there.

Thanks because writing the formula in a different way made me to realize that the problem was not in the formula!