subtract values of Column A and Column B

[jcoolen09]

I want to subtract the values from Column A and Column B 

For example, for the first row, I would expect the New Column value to be the difference between 16.7 - 5.10, so I would expect a new value in New Column to be 11.6. The basic subtraction measures I've tried are giving results that make no sense to me. It's worth mentioning that Column B is Summed and Column A is not. 

please help! Thanks!

[jcoolen09 · Accepted solution]

solved this by using a Group By in the Transform Data. That seemed to fix up the calculations

[nvprasad]

Hi Jcoolen09,

Can you try the below measure?

Difference = CALCULATE(SUM(Data[A])-SUM(Data[B]))

Thank you,

If this solution helps, then please consider Accept it as the solution  to help the other members find it more quickly.

[jcoolen09]

That does not work