Forum Discussion

vipinrajan's avatar
vipinrajan
Frequent Visitor
1 year ago
Solved

Sum Multiple column

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.

 

Column1Column2Total
 55
101010
202020
303030
35 35
25 25
   

 

Please help.

 

Regards,

Vipin

  • vipinrajan's avatar
    vipinrajan
    1 year ago

    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
    )
    )
    )

1 Reply

  • vipinrajan's avatar
    vipinrajan
    Frequent Visitor
    1 year ago

    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
    )
    )
    )