Sum of average measure not calculating correctly

[nleuck_101]

Hello All,

I'm having some trouble to get the correct sum calculation on an average measure. I've attached a screenshot below. I first measure is Avg Headcount = AVERAGE(table[AssociateCount]). The second measure is Total Avg Headcount = SUMX(VALUES(table[Supervisor]), [Avg Headcount]). The first measure gets me the average per supervisor total and I don't want that. The second measure I thought would get me closer but the math doesn't add up. 23 is not 9+9+9+1+8+3, it should be 39. Am I missing something? Any help would be greatly appreciated. Thanks!

[Greg_Deckler]

@nleuck_101 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

[nleuck_101]

Hello @Greg_Deckler 

So this doesn't help me at all. I'm still getting 23.

[Anonymous]

Hi @nleuck_101 ,

Could you provide more context for this visual? Are there any other grouping fields in the visual besides table[Supervisor]?

It would be nice to have an example file that does not contain private data.
How to provide sample data in the Power BI Forum

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

[nleuck_101]

@Anonymous 

There is Section, Shift, Supervisor, First Name, Last Name. I also have two slicers Section, Shift.

[Anonymous]

Hi @nleuck_101 ,

Please try this measure:

Measure = SUMX( SUMMARIZE('Table','Table'[Section],'Table'[Shift],'Table'[Supervisor],'Table'[First Name],'Table'[Last Name],"@avg",AVERAGE('Table'[AssociateCount])), [@avg] )

Best Regards,
Gao
Community Support Team

If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group