Calculate Total Excluding Row Contribution

[rawiswarden]

Hello,

If I have a simple table like this, where amount is a measure.  What is the DAX to get the total of column Amount excluding that row?

As you can see, the What If Amount is just the total (194) less the amount for each person.  But I can't figure this out and it must be something simple.

Name	Amount	What If Amount
A	22	172
B	20	174
C	38	156
D	40	154
E	12	182
F	34	160
G	28	166
H	0	194
Total	194

I did the calculation with something like this:

= CALCULATE( sum(Dimension_Dealer[B]), ALL(Dimension_Dealer)) - [Booked Count]

But I'm trying to do this all in a calculate or interator function to learn.  Thanks!

[az38 · Accepted solution]

Hi @rawiswarden 

try a measure like

Measure = 
calculate(sum(Table4[Amount]);FILTER(ALL('Table4');Table4[Name]<>SELECTEDVALUE(Table4[Name])))

do not hesitate to give a kudo to useful posts and mark solutions as solution

[rawiswarden]

Awesome!  Selected value is what I needed to know.