Forum Discussion

3 Replies

  • BA_Pete's avatar
    BA_Pete
    Super User
    3 years ago

    Hi asdf1608 ,

     

    Try this as a measure:

    COALESCE(SUM(yourTable[Column1]) + SUM(yourTable[Column2]), 0)

     

    Pete

    • asdf1608's avatar
      asdf1608
      Helper V
      3 years ago

      BA_Pete I tried the same but the values seems to be wrong.

      In tableau I got another value and in Power bI got another value. 

      Is there any other reasons

      • BA_Pete's avatar
        BA_Pete
        Super User
        3 years ago

         

        Almost impossible to say without being able to see the detail behind it all.

        Coalesce should work fine, but you could try this as an alternative:

        VAR __calc =
SUM(yourTable[Column1]) + SUM(yourTable[Column2])
RETURN
IF( ISBLANK(__calc), 0, __calc)

         

        Pete