Forum Discussion
SWITCH function help (does not support comparing values of type true/false)
Hi I have a measure that is supposed to be determining whether certain values are met, and should sort them into either tiers 1, 2, 3, or 4. I am getting an error that says the switch function does not support comparing values of type text with values of type true/false. Could someone explain what I am doing wrong? Thank you.
Hi abeirne ,
Could you try this? 🙂
SA Anc/Car = IF( [ANC $/ Car SA] >= 43.50, Switch( TRUE, [ANC $/ Car SA] <= 49.49, 1, [ANC $/ Car SA] >= 49.50 && [ANC $/ Car SA] <= 55.99 , 2, [ANC $/ Car SA] >= 56 && [ANC $/ Car SA] <= 65.99, 3, [ANC $/ Car SA] >= 66.00, 4 , 0) ,0)
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
3 Replies
Hi abeirne ,
Could you try this? 🙂
SA Anc/Car = IF( [ANC $/ Car SA] >= 43.50, Switch( TRUE, [ANC $/ Car SA] <= 49.49, 1, [ANC $/ Car SA] >= 49.50 && [ANC $/ Car SA] <= 55.99 , 2, [ANC $/ Car SA] >= 56 && [ANC $/ Car SA] <= 65.99, 3, [ANC $/ Car SA] >= 66.00, 4 , 0) ,0)
Let me know if this helps 🙂
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/Yes the 'true' works! Would you be willing to explain why this works? Thank you for your help. 🙂
Hi abeirne ,
I hope it's okay if I just post you some links that I think are great to read up on:
How To Use SWITCH True Logic Function In Power BI | Enterprise DNAPower BI: Use DAX Switch Function to Make IF Functions Easier (pragmaticworks.com) (especially the video is great)
/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/
