filter dax > 40 not working, why?

[Anonymous]

I am troubleshooting why my code doesnt work and I notice this:

 If i put > 40

doesnt work!!!

I need to write > 41 to filter out those "40" , why is this??

This is the source from sql server (it adds to 40, not more!)

[AlexisOlson · Accepted solution]

It's possible that floating-point math is making it very slightly larger than 40. To check you can try rounding [summ] before comparison.

Try writing this instead to round to two decimal places:

ROUND ( [summ], 2 ) > 40