I hope I'm not going crazy - it seems that Power BI is adding some random junk to the very far decimal positions when doing some basic math operations.
Let's do some basic test:
Column = (1-0.5-0.5)=0
This produces TRUE, as expected.
Column = (1-0.6-0.4)=0
Column = (1-0.7-0.3)=0
I noticed that when comparing a KPI threshold of 0.05 to a number which was basically (1-19/20), which is 1/20, which is exactly 0.05.
However, that does not seem to be the case in Power BI:
Note that I'm working only with numbers entered directly here, there are no columns involved, whose data type settings could be at play.
Is there an explanation for this?
I have tried this in multiple projects.
I'm using Microsoft Power BI Desktop (Optimized for Power BI Report Server - August 2018)
Version: 2.61.5192.641 32-bit (August 2018)