Forum Discussion

shakavi's avatar
shakavi
New Member
4 years ago
Solved

Filter with ABS partially works

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!

 

ABS
Filter
  • tamerj1's avatar
    tamerj1
    4 years ago

    Hi shakavi 
    Please try

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

2 Replies

  • shakavi's avatar
    shakavi
    New Member
    4 years ago

    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!

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Hi shakavi 
    Please try

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