Forum Discussion
SemG
Advocate I
Advocate ICrossjoins behaving unexpectedly
Hi, I have a problem trying to roll up values in Power BI. What I am trying to accomplish: - I have a list of hours booked on a certain day by a certain person in multiple lines. - Roll up t...
Found the solution. The problem is caused by a well known problem of comparing two floating point numbers. Both numbers need to be explicitly rounded to 2 digits for it to work. A night of sleep can do a lot of good. Thanks for responding!
SemGAdvocate I
Advocate IHi,
Thanks for responding. Because the grand total evaluates to 0 if you just use IF. Also, I just checked an it had the same problem. Certain values that clearly need to get evaluated to 0 get evaluated to 1. Anyone?
SemGAdvocate I
Advocate IFound the solution. The problem is caused by a well known problem of comparing two floating point numbers. Both numbers need to be explicitly rounded to 2 digits for it to work. A night of sleep can do a lot of good. Thanks for responding!
v-chuncz-msftCommunity Support