Forum Discussion

SemG's avatar
SemG
Icon for Advocate I rankAdvocate I
8 years ago
Solved

Crossjoins 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...
Need Help
  • SemG's avatar
    SemG
    8 years ago

    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!

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
8 years ago

Hi,

 

Why not simply use

 

=IF(calculate(SUM([Hours])<SELECTEDVALUE(MySlicer),1,0)

 

Hope this helps.

SemG's avatar
SemG
Icon for Advocate I rankAdvocate I
8 years ago

Hi,

 

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?