Subtracting from same column and then add up the difference

[Varez42]

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?

[tamerj1 · Accepted solution]

Hi @Varez42 

please try

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

[Varez42]

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 .

[KeyurPatel14]

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