Solved: filter dax > 40 not working, why?

Anonymous · ‎01-31-2022

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 · ‎01-31-2022

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

AlexisOlson · ‎01-31-2022

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

filter dax > 40 not working, why?