Average number of employees at a certain level per project

[elaiken3]

I am trying to make a sheet that will display the average number of employees at a certain level per project. The data I have looks like this:

Project ID	Employee ID	Employee Title
10001	kdk155	Entry
10001	sdf166	Entry
10001	dgr856	Entry
10001	snf965	Mid
10001	fot354	Mid
10001	rrg855	Mid-Senior
10001	plf556	Senior
10002	wes749	Entry
10002	hcv247	Entry
10002	dod653	Entry
10002	ydf417	Entry
10002	cbn852	Mid
10002	pls745	Mid
10002	kcq384	Mid
10002	idj721	Mid-Senior
10002	rid939	Senior
10002	mhd454	Senior

How would I calculate, as a measure, the average count of each Employee Title per Project. I have been getting pretty funky numbers here lately with the formulas I've been using. Any help provided would be much appreciated. Thanks.

[Lisa_P · Accepted solution]

Is this what you are looking for ?

[elaiken3]

Yes it is generally. It actually worked when I put it like this:

Avg(Aggr(Count([Employee Title]),[Project ID],[Employee ID]))

Thank you!