Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

IF Conditional filter

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 

Need Help
  • AntrikshSharma's avatar
    AntrikshSharma
    6 years ago

    Try this instead:

    =
VAR Sales = [Sales]
VAR Result =
    SWITCH ( TRUE (), Sales < 499, "Low", Sales < 999, "Medium", "High" )
RETURN
    Result
  • v-diye-msft's avatar
    v-diye-msft
    6 years ago

    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"

)

)

2 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Community Champion
    6 years ago

    Try this instead:

    =
VAR Sales = [Sales]
VAR Result =
    SWITCH ( TRUE (), Sales < 499, "Low", Sales < 999, "Medium", "High" )
RETURN
    Result
  • v-diye-msft's avatar
    v-diye-msft
    Community Support
    6 years ago

    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"

)

)