Average of a count

[JillHenninger]

I'm convinced this is an easy solve, but I've not been able to figure it out! I need to get the average # of clients per person (which should be 6.375 [102 total clients/ 16 people)) but I cannot figure out the Dax. I will also need this by team (each person is on a team). Will I need a separate formula for that?

Thank you in advance

CCI Associate	# of Clients	# of Retailers	# of Intersections
Person 1	11	6	58
Person 2	4	5	17
Person 3	6	14	68
Person 4	6	8	43
Person 5	5	15	52
Person 6	6	6	36
Person 7	4	7	28
Person 8	8	8	56
Person 9	11	6	57
Person 10	5	7	35
Person 11	3	15	31
Person 12	7	6	39
Person 13	5	15	30
Person 14	8	6	45
Person 15	8	9	59
Person 16	5	15	38

[camargos88]

@JillHenninger ,

Check the attached file. You can use this measure for a card:

_Average = DIVIDE(SUM('Table'[# of Clients]), DISTINCTCOUNT('Table'[CCI Associate]),0)

and this one for a table:

_Average 2 = CALCULATE([_Average], ALL('Table'))

[JillHenninger]

Thank you! So - I evidently left out a key point. "# of clients" is a measure itself (noted below) - it counts text. I think that's where I got stuck... 

# of Clients = DISTINCTCOUNTNOBLANK('Assignments Input'[Client Name])