topic Re: Subtracting from same column and then add up the difference in DAX Commands and Tips

Subtracting from same column and then add up the difference

Varez42 — Wed, 15 Mar 2023 16:19:07 GMT

I have data kind of similar to this excel file in the PQ, I would like to get the difference of value column between sent and reci(att column) for each unique event ID

I was able to get that where for a the measure would be 10 and for b it would be 15 and for c 0 but the total is not adding up as it should be 25
I am trying to calculate it like this

Can some one help me with this,please?

Re: Subtracting from same column and then add up the difference

KeyurPatel14 — Wed, 15 Mar 2023 11:01:25 GMT

Hi Varez42 ,
Can you please provide sample output for better understanding?

Re: Subtracting from same column and then add up the difference

Varez42 — Wed, 15 Mar 2023 13:46:14 GMT

HI KeyurPatel14
thanks for the response,
So based on the above data , I am trying something like this but as you can see the total should be 50 but it is not .

Re: Subtracting from same column and then add up the difference

tamerj1 — Wed, 15 Mar 2023 15:08:01 GMT

Hi Varez42

please try

=
SUMX ( 'Table', IF ( 'Table'[att] = "reci", - 'Table'[Value], 'Table'[Value] ) )