Average of Multiple Filtered Sums

KMichael99 — Tue, 07 Nov 2023 14:32:25 GMT

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!

Re: Average of Multiple Filtered Sums

djurecic — Tue, 07 Nov 2023 15:57:04 GMT

Hi KMichael99 ,

You might look into the SUMMARIZECOLUMNS function.

https://dax.guide/summarizecolumns/

topic Re: Average of Multiple Filtered Sums in DAX Commands and Tips

Average of Multiple Filtered Sums

Re: Average of Multiple Filtered Sums