Switch DAX showing wrong results

Hi  bilalkhokar73 ,

You can convert it to measure.

1. Create measure.、

Measure =
SWITCH(
   TRUE(),
   AND([achvd%]>=0.000001,[achvd%]<=0.0999999),"001111",
   AND([achvd%]>=0,[achvd%]<=0.4),"0",
   AND([achvd%]>0.41,[achvd%]<=0.6),"60",
   AND([achvd%]>0.61,[achvd%]<=0.7),"70",
   AND([achvd%]>0.71,[achvd%]<=0.8),"80",
   AND([achvd%]>0.81,[achvd%]<=0.9),"90",
   AND([achvd%]>0.91,[achvd%]<=1),"100",
   AND([achvd%]>1.1,[achvd%]<=9.9),"125.5",
   AND([achvd%]>14,[achvd%]<=100),"14100",
   "0")

2. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly