Help trying to get averages

Hi all,  

Apologies if I have posted this in the wrong section.

I have a situation where I need to get a few different averages, and they all come from the same source data, in a table called Team Reps.   At the moment I am building a Matrix visualisation which has the different sectors across the top, and the rest is all different measures working its way down.

I also have a Date filter which is not connected to any table and I instead use a VAR in my measures to get the date for any comparisions.

The issue I am having for this example is that I need to the Average Number of Companies per Team, it is currently done manually by creating a pivot table in Excel and then selecting the rows relevant to the sector and getting the average from the bottom of the screen based on the selection.

I have tried a few different ways of looking at it, grouping it in the transform data area, or creating a new summized table, but the issue comes when I try to introduce any Date logic in to the equation as the entire matrix should change based on the month selected.

This is a basic example of the data I am looking at.

Any help would be appriciated.

Thanks!