Average of Multiple Filtered Sums

[KMichael99]

Hi Guys,

I'm looking to calculate the Average Weekly Total Distance for different positional groups within my dataset. 

I have a data dump with columns defining date, training week, player name, position group, and total distance. There is multiple dates, and therefore rows, for each training week. Therefore to calculate weekly total distance I'll need to sum multiple rows. 

I want to visualise an average weekly total distance for each positional group. To do this, I believe I need to sum every players weekly total distance, and then average these sums. I'll then need to filter this to each positional group via a slicer. 

Any ideas what DAX formulas I should be using? Thanks!

[djurecicK2 · Accepted solution]

Hi @KMichael99 ,

 You might look into the SUMMARIZECOLUMNS function.

https://dax.guide/summarizecolumns/