topic Re: Add two or more columns with a condiotion in DAX Commands and Tips

Add two or more columns with a condiotion

DryMouse555 — Fri, 21 Jun 2024 06:01:15 GMT

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

Re: Add two or more columns with a condiotion

manvishah17 — Fri, 21 Jun 2024 06:11:22 GMT

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!

Re: Add two or more columns with a condiotion

ThxAlot — Fri, 21 Jun 2024 07:57:51 GMT

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

Re: Add two or more columns with a condiotion

DryMouse555 — Sun, 23 Jun 2024 23:43:31 GMT

Thank you ThxAlot && manvishah17