Measure is not rounded to 2 digits, although column is

[michaelsh]

If I format my measure with 12 decimal places, I see numbers such:

0.000000000004 (should be 0)

-19.999999999998 (which is -20)

I doubled checked, my measure is formatted as a Decimal Number with 2 decimal places.

I also dbl-check my column, which the measure sums - it is also a Decimal Number with 2 decimal places.

I also added Round step in Power Query to 2 decimal places.

Still facing this issue.

My measures often check for zeros, so IF(Measure=0,true(),false()) returns FALSE while it is 0.

I solved it for now by doing >-0.01&&<0.01 but why is it like this?

[v-lili6-msft]

hi

Try to change the data type of this column from Decimal Number to Fix Decimal Number, then set 2 decimal places.

this should work for you.

Regards,

Lin