IF AND statement give me a wrong result

[lsldufan]

I created a column called A Achieved which =1 if  all total score>=1.8,classification=A else =0

Seems all result correct but 1, I don't know where is wrong, is it something wrong with the data or with my expression? Many thanks

[lsldufan · Accepted solution]

I fix the issue by changing data type from number decimal to number decimal fixed, and change back to number decimal

[lsldufan]

I cleanned the data, and did a test, when I set total impact as 2.8, then it will follow the fomula, so I don't think this is the data format issue, I think both classification and total impact were calculate correct, but don't know why it was not follow fomula when the result =1.8

[daXtreme]

Can't you just write several simpler formulas/columns to diagnose whether the problem comes from the text field or the numeric one? Having an AND condition to troubleshoot is not the best idea.

[Whitewater100]

Hi:

You formula looks normal.

I have a measure like this:

IF(

   AND(Table[actcod] = “CASRPL”,

       Table[Time over/under] = “Time Under 5”),

   1), BLANK()

)

I'm wondering if you can add a ) after the first 1     >=1.8,1),0)

[daXtreme]

Before you load data into PowerBI, cleanse it well in the source or in Power Query. Do not ever trust your eyes.

[johnt75]

Is there trailing whitespace in the classification column on that particular row ?