Averaging data accross segments of different sizes

[enlamparter]

I apologize for the vague/poorly worded title. I couldn't think of how to explain this issue!

I have a data model that I'm trying to replicate graphically in Power BI. This data model shows the amount of time that should be spent working on each category depending on the person's position division, team, and title (i.e. Sales, Research Team, Analyst). It provides the average time allotted at the team, division, and overall levels. This average also takes into account the number of people working in each position. For example, if there are two supervisors spending 25% of their time on a project, two analysts spending 22.5% of their time on the same project, and four specialists spending 0% of their time on the project, the average would be  about 11.9%.

I'm not quite sure how to recreate this graphically in Power BI. I have a table with the raw percentages per position, and a table that indicates the number of employees per position, but how can I combine this information to get accurate averages displayed on my charts?

Thanks so much!

[enlamparter · Accepted solution]

After I got the team information for the head count table, I solved this by adding in an "Adjusted Time" column to the first table that multiplies Time Allotted by the number of employees in each particular role. When I made my chart, the averages then came out as expected.

[Greg_Deckler]

The answer is going to depend on how your data is laid out. Example/mock data please.

[enlamparter]

The relevant data is broken into two tables. The resource table (second table) gets the head count from a third table that lists all employees and which group & role they have. (I know I need to add in the resource team as well, but I'm still trying to get that information).