Forum Discussion

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