PowerWhy's avatar
PowerWhy
Icon for Helper IV rankHelper IV
3 years ago
Status:
Needs Info

Bug with "less than visualisation" filter

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%20less%20than%20or%20equal%20to.pbix?dl=0 

 

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)

3 Comments