Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
I fix the issue by changing data type from number decimal to number decimal fixed, and change back to number decimal
I fix the issue by changing data type from number decimal to number decimal fixed, and change back to number decimal
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
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.
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)
Before you load data into PowerBI, cleanse it well in the source or in Power Query. Do not ever trust your eyes.
Is there trailing whitespace in the classification column on that particular row ?
User | Count |
---|---|
51 | |
37 | |
20 | |
14 | |
13 |
User | Count |
---|---|
94 | |
72 | |
30 | |
21 | |
13 |