Forum Discussion
convert text to int
How to resolve the below issue, i tried to convert text to into by value and format but still throwing error.
Isdiplay = IF([Top 50 rank]<=SELECTEDVALUE('Data'[Data Unit ]),1,0)
Anonymous I assume Top 50 Rank is a number and Business Unit is a text
IsDisplay = IF ( [Top 50 Rank] <<= VALUE ( SELECTEDVALUE ( 'Business Unit'[Business Unit] ) ), 1, 0 )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
1 Reply
- parry2k
Super User
Anonymous I assume Top 50 Rank is a number and Business Unit is a text
IsDisplay = IF ( [Top 50 Rank] <<= VALUE ( SELECTEDVALUE ( 'Business Unit'[Business Unit] ) ), 1, 0 )I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!