Add two or more columns with a condiotion

[DryMouse555]

Hi,

I have the below data,

Column A	Column B	Column C
ABC	Map	$56
EFG	Camera	$89
IJK	Electricity	$789

I want to do Sum (Column C, where Column A =ABC and Column B =Map) + Sum (Column C, where Column A =EFG and Column B =Camera) + Sum (Column C, where Column A =IJK and Column B =Electricity)

Can you tell me how to do in Power BI dax?

Thanks

[manvishah17 · Accepted solution]

Hi @DryMouse555 ,
You can try out this DAX Measure,

TotalSum = 
SUMX(
    'YourTable',
    SWITCH (
        TRUE (),
        'YourTable'[Column A] = "ABC" && 'YourTable'[Column B] = "Map", 'YourTable'[Column C],
        'YourTable'[Column A] = "EFG" && 'YourTable'[Column B] = "Camera", 'YourTable'[Column C],
        'YourTable'[Column A] = "IJK" && 'YourTable'[Column B] = "Electricity", 'YourTable'[Column C],
        0  -- Default case, if none of the conditions match
    )
)

 or this one..

TotalSum = 
SUMX(
    FILTER(
        'YourTable',
        ('YourTable'[Column A] = "ABC" && 'YourTable'[Column B] = "Map") ||
        ('YourTable'[Column A] = "EFG" && 'YourTable'[Column B] = "Camera") ||
        ('YourTable'[Column A] = "IJK" && 'YourTable'[Column B] = "Electricity")
    ),
    'YourTable'[Column C]
)

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

[DryMouse555]

Thank you @ThxAlot && @manvishah17 

[ThxAlot · Accepted solution]

A straightforward way if you have no much knowledge of DAX,

Sum1 = 
CALCULATE(
    SUM( DATA[Column C] ),
    DATA[Column A] = "ABC" && DATA[Column B] = "Map"
        || DATA[Column A] = "EFG" && DATA[Column B] = "Camera"
        || DATA[Column A] = "IJK" && DATA[Column B] = "Electricity"
)

Another way in a more "DAX manner",

Sum2 = 
CALCULATE(
    SUM( DATA[Column C] ),
    TREATAS(
        { ( "ABC", "Map" ), ( "EFG", "Camera" ), ( "IJK", "Electricity" ) },
        DATA[Column A],
        DATA[Column B]
    )
)

[manvishah17 · Accepted solution]

Hi @DryMouse555 ,
You can try out this DAX Measure,

TotalSum = 
SUMX(
    'YourTable',
    SWITCH (
        TRUE (),
        'YourTable'[Column A] = "ABC" && 'YourTable'[Column B] = "Map", 'YourTable'[Column C],
        'YourTable'[Column A] = "EFG" && 'YourTable'[Column B] = "Camera", 'YourTable'[Column C],
        'YourTable'[Column A] = "IJK" && 'YourTable'[Column B] = "Electricity", 'YourTable'[Column C],
        0  -- Default case, if none of the conditions match
    )
)

 or this one..

TotalSum = 
SUMX(
    FILTER(
        'YourTable',
        ('YourTable'[Column A] = "ABC" && 'YourTable'[Column B] = "Map") ||
        ('YourTable'[Column A] = "EFG" && 'YourTable'[Column B] = "Camera") ||
        ('YourTable'[Column A] = "IJK" && 'YourTable'[Column B] = "Electricity")
    ),
    'YourTable'[Column C]
)

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!