Calculate average with reference to another table - matrix

Hi Anonymous ,

My apologies, seems like you've already added up number of employees in your other table. In that case, you'll just need to do the sum:

Employees = SUM(employees[Number of employees])

then divide the two measures:

Average Employee Time = 
VAR _Hours = [SUM_Activities12]
VAR _Employees = [Employees]        // Employees = SUM(employees[Number of employees])
RETURN
DIVIDE(_Hours, _Employees)

Based on your sample data I would return this expected output:

Hi,

PBI file attached.

Hope this helps.