SWITCH function help (does not support comparing values of type true/false)

[abeirne]

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. 

SA Anc/Car =

IF(

[ANC $/ Car SA] >= 43.50,

Switch( [ANC $/ Car SA],

[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)

[tackytechtom · Accepted solution]

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/

[abeirne]

Yes the 'true' works! Would you be willing to explain why this works? Thank you for your help. 🙂

[tackytechtom]

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 DNA

Power 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/