Forum Discussion
Helper IIICannot see total value for measure
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:
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
2 Replies
- Greg_Deckler
Community Champion
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 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
