Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
plaliberte
Frequent Visitor

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")
0 REPLIES 0

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.