Less than filter unexpected behaviour

[PowerWhy]

Hello,

For this file https://www.dropbox.com/s/6pn9gcjg9zmmu6m/Test%20-%20Less%20than%20filter%20unexpected%20behaviour%2... please can someone tell me why the right table is returning one row? The filter is set to less than 0.4, and the row is showing 0.4 so I'm a bit puzzled 🙂

The file was originally created in December 2021 version of power bi, but I've opened in December 2022 version and resaved, so I think this file includes all bug updates.

Many thanks for any help!

PW

[PowerWhy]

Hi @Mikelytics  the decimals are just the formatting on the output for testing. The inputs only have 2 decimal places. Also doing the sum the other way round is 688.80 / 0.4 = 1722.00 exactly so I don't see what decimal numbers could be in the calculation?

[Mikelytics]

 @PowerWhy 

Maybe the raw data are like 0,399999999999999999999999999 for one row and fot hte others not? you have so many decimal numbers. Maybe you should do rounding in Power Query to two decimals.

Best regards
Michael
-----------------------------------------------------
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Appreciate your thumbs up!
@ me in replies or I'll lose your thread.