Forum Discussion

SemG's avatar
SemG
Advocate 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
Super User
8 years ago

Hi,

 

Why not simply use

 

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

 

Hope this helps.

  • SemG's avatar
    SemG
    Advocate 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?

    • SemG's avatar
      SemG
      Advocate I
      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!

      • v-chuncz-msft's avatar
        v-chuncz-msft
        Community Support
        8 years ago

        SemG,

         

        Glad to hear that. You may help accept solution. Your contribution is highly appreciated.