Forum Discussion

LFM's avatar
LFM
Icon for Helper III rankHelper III
1 year ago
Solved

Cannot 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? ...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    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's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
1 year ago

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