Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
688.8 / 1722.00 is 0.4 (or 40%) exactly
However if I filter a visualisation by "less than 0.4" (as I have done on the right hand side of the file below) then the result of 40% is displayed in error.
The file is at https://www.dropbox.com/s/1zsqsk2hexw5rfz/Test%20-%20less%20than%20filter%20being%20treated%20as%20l...
Proof that 688.8 / 1722.00 = 40% exactly (not 39.999999999999.... recurring %):
688.8 / 1722 (original fraction)
6888 / 17220 (multiplied top and bottom of fraction by 10)
2/5 (divided top and bottom of fraction by 3444)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.