Forum Discussion
IF AND statement give me a wrong result
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
I fix the issue by changing data type from number decimal to number decimal fixed, and change back to number decimal
6 Replies
daXtremeSolution Sage
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.
johnt75Super User
Is there trailing whitespace in the classification column on that particular row ?
- daXtreme
Before you load data into PowerBI, cleanse it well in the source or in Power Query. Do not ever trust your eyes.
Whitewater100Hi:
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)
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
I fix the issue by changing data type from number decimal to number decimal fixed, and change back to number decimal