I have a 2 columns and do difference

[dshah12]

Appl no	sum of fore	recomm
1	100	126
2	200	200

I want to do the difference of the  sum of fore - recomm,  but i don't want that it sums the recomm 

I tried calculated column but it does not work

Help  appreaciated !
Thank you 

[vojtechsima]

Hi, @dshah12 ,

bit confusing, but do you want it like this?

Measure:

Total Difference = SUMX('Table', 'Table'[sum of fore] - 'Table'[recomm])

[dshah12]

Hi thank for the reply but this formula will sum the recomm amount I don't want that it should be without that 

[vojtechsima]

@dshah12 but how do you wanna they display it, you can see that if you put to each line, it's not a sum, but it i a individual level.

Do you want it as calculated column then, or could you give me please example of the result?