topic Re: DAX SUM formula not working when field is removed from Table visual in DAX Commands and Tips

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

Auto_queen — Tue, 20 Sep 2022 21:36:53 GMT

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 — Tue, 20 Sep 2022 21:52:13 GMT

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

Auto_queen — Tue, 20 Sep 2022 22:23:16 GMT

Worked thank you