Sort a TEXT field

[Anonymous]

Hi ,

Hi,

I have a DAX as below where if the field is "Red OR Amber" then I show the value else its blank.

Column = IF(Table1[Health] IN {"Red","Amber"} ,Table1[Values],"")

The challenge is that if I use this - I cannot sort as the column has to be modeled as Text.

Sorting by Table1[Values] is showing error.

How can I fix this?

Need Help!

Thanks

[amitchandak · Accepted solution]

@Anonymous 

Use blank()

Column = IF(Table1[Health] IN {"Red","Amber"} ,Table1[Values],blank())