Forum Discussion
Sort a TEXT field
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
Anonymous
Use blank()
Column = IF(Table1[Health] IN {"Red","Amber"} ,Table1[Values],blank())
1 Reply
- amitchandak
Super User
Anonymous
Use blank()
Column = IF(Table1[Health] IN {"Red","Amber"} ,Table1[Values],blank())