Sum Multiple column

[vipinrajan]

Dear All,

From DAX how to get TOTAL based on below table, if coulmn1 and 2 same value then its sould pick either one and remain raws based on value.

Column1	Column2	Total
	5	5
10	10	10
20	20	20
30	30	30
35		35
25		25

Please help.

Regards,

Vipin

[vipinrajan · Accepted solution]

NewColumn =
IF( TableName[Column1] = TableName[Column2],
TableName[Column1],
IF( TableName[Column1] = 0 && TableName[Column2] = >0,
TableName[Column2],
IF( TableName[Column1] = >0 && TableName[Column2] = 0,
TableName[Column1],
BLANK() -- Or any other default value if no condition matches
)
)
)