Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Individual and Group average

Hello,   I have the following puzzle that I am trying to resolve and so far I was not able to find a good solution to it (DAX).   The raw data table looks like: Name Activities Date John...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
7 years ago

hi, Anonymous 

This looks like a measure totals problem. Very common. See this post about it
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

 

For your case,  just try this formula:

Measure = var _table=SUMMARIZE(Table1,Table1[Name],"Avg Activities",[Avg Activities]) return
AVERAGEX(_table,[Avg Activities])

Result:

 

Best Regards,

Lin

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thank you!.

     

    I've just combined your answer with an additional mesasure using HASONEFILETER to come out with a final table:

     

    Now both totals and Team average show the right numbers.