Cannot see total value for measure

[LFM]

Hello. I have a measure called "average abs total value". When I put it into a table visual,  the totals are not summing them correctly. 
What can I do to see the total sum of all the values?

The measure looks like this:

Avg. abs total value per day = AVERAGE(ERS[Absolute Total Value])

[Anonymous · Accepted solution]

Hi @LFM ,

In Power BI, total row is calculated independently based on the current context, rather than simply adding up the detail rows.

You can use SUMX to fix the Total.

Avg. abs total value per day = SUMX(ERS,AVERAGE(ERS[Absolute Total Value]))

Best regards,

Mengmeng Li

[Greg_Deckler]

@LFM First, please vote for this idea: https://ideas.powerbi.com/ideas/idea/?ideaid=082203f1-594f-4ba7-ac87-bb91096c742e

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

Also: https://youtu.be/uXRriTN0cfY
And: https://youtu.be/n4TYhF2ARe8