Need help with DAX

[asdf1608]

I need to convert the tableau calculated field to Power BI

zn(sum([column 1]) + sum([column 2]))

Thanks in advance

[BA_Pete]

Hi @asdf1608 ,

Try this as a measure:

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

Pete

[asdf1608]

@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]

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