Forum Discussion

plaliberte's avatar
plaliberte
Frequent Visitor
6 years ago

DAX comparison operations do not support comparing values of type True/False with values of type Int

HI,  

 

I am not sure where my error is in the below switch statement.   I keep getting the error on the subject line.  Any and all help is appreciated.

 

Column = SWITCH (TRUE(),
AND ([# of Staffed Beds] >0,[# of Staffed Beds] <=24), "Less than 25",
AND ([# of Staffed Beds] >=25,[# of Staffed Beds]<=49),"25-49",
AND([# of Staffed Beds] >= 50, [# of Staffed Beds]) <= 99, "50-99",
AND ([# of Staffed Beds] >= 100, [# of Staffed Beds] <= 249), "100-249",
AND ([# of Staffed Beds] >= 250, [# of Staffed Beds]<= 499), "250-499",
AND ([# of Staffed Beds] >= 500,[# of Staffed Beds]<= 999), "500-999",
AND ([# of Staffed Beds] >=1000, [# of Staffed Beds]<= 9999999999999999999), "1,000+", BLANK(),
"Unknown")
No RepliesBe the first to reply