IF Conditional filter

[Anonymous]

Hello All, 

I want to set filter range with with IF but the result have worng range . 

Sales 0 < 499   Low 

Sales  500 to 999 Medium 

Sales >= 1000    High 

I used following formula and the result showed wrong range. Is it due to date ? 

IF(

[Sales] <= 499, "Low"

IF(

[Sales] .= 1000, "High", "Medium"

)

) 

Thansk in advance for your help 

SweZin 

[AntrikshSharma · Accepted solution]

Try this instead:

=
VAR Sales = [Sales]
VAR Result =
    SWITCH ( TRUE (), Sales < 499, "Low", Sales < 999, "Medium", "High" )
RETURN
    Result

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Change it to this measure instead:

IF(

max('table'[Sales]) <= 499, "Low",

IF(

max('table'[Sales]) >= 1000, "High", "Medium"

)

) 

 

Or the column instead:

Column = IF(

[Sales] <= 499, "Low",

IF(

[Sales] >= 1000, "High", "Medium"

)

) 

[AntrikshSharma · Accepted solution]

Try this instead:

=
VAR Sales = [Sales]
VAR Result =
    SWITCH ( TRUE (), Sales < 499, "Low", Sales < 999, "Medium", "High" )
RETURN
    Result