Average of Average

[EmmanuelleD]

Hi all, 

I can't find a solution to my problem so I'm asking for your help. 

I have a measure calculating the average number of jobs done by an employee per day which works fine:

Average Completion by Worked Day = AVERAGEX(VALUES('Completed RMs'[ActivityDate]),[Jobs Completed])

I would like to get the average per employee category (some employees are expected to complete more jobs per day than others): 

AVG per category = CALCULATE([Average Completion by Worked Day], ALLEXCEPT('Engineers Categories','Engineers Categories'[Category]))

But see below (last row) that last measure gives me an average of 212.65 for the selected category which is not what I want. I'd like it to show that on average, an employee in this category completes 35 jobs per day so we can identify who is above or below the average. 

Thanks in advance! 

[EmmanuelleD · Accepted solution]

Found the solution which was simply : 

AVG per category = CALCULATE(AVERAGE('Jobs Completed'[Count]), ALLSELECTED('Engineers Categories'[Category]))

[amitchandak]

@EmmanuelleD , I think you have to try like

AVERAGEX(VALUES('Engineers Categories'[Category]),[Average Completion by Worked Day])

[EmmanuelleD]

This gives me the same result as the above measure unfortunately. 

I don't understand the logic to get to 212.65. Do you?