DAX SUM formula not working when field is removed from Table visual

[Auto_queen]

Hello, 

I have a simple formula 

Total Adjust Fee Amount = 

SUM('Closing Report'[TR1__Adjusted_Fee_Amount__c]

The total is correct when the "Name" field is added to the table visual, but when I remove the "Name" field the total is very wrong.  (See picture). 

I tried this formula:

Total Adjust Fee Amount =

SUMX(

    VALUES('Closing Report'[Name]),

    CALCULATE(SUM('Closing Report'[TR1__Adjusted_Fee_Amount__c])

    )

)

but it doesn't do anything. I'm very stuck. Please help.

[Greg_Deckler · Accepted solution]

@Auto_queen Try:

Measure =
  VAR __Table = SUMMARIZE('Table','Table'[Name],"__Sum",SUM('Closing Report'[TR1_Adjusted_Fee_Amount_c[))
RETURN
  SUMX(__Table,[__Sum])

[Auto_queen]

Worked thank you