Average of Count within a group

[DjDon]

Hi all,

Im looking for a single measure I can place in a card that displays the average number of items in a group category.

In the dataset below, I'd like the card to display 3 which is the average count of Item Codes per Office Location.  Item codes are unique.

Have tried several variants using GROUPBY but no success.  Thanks for any help!

Data		Looking for overall average:
Office Loc code	Office	Item Code				Avg Items
OfficeA	Office location A	A00025			OfficeA	4
OfficeA	Office location A	A00049			OfficeB	2
OfficeA	Office location A	A00073			OfficeC	3
OfficeA	Office location A	A00193			Overall Average:	3
OfficeB	Office Location B	A00313
OfficeB	Office Location B	A00385
OfficeC	Office Location C	A00409
OfficeC	Office Location C	A00481
OfficeC	Office Location C	A00505

[stevedep · Accepted solution]

Hi,

pls see below:

Measure = AVERAGEX(VALUES('Table'[Office]), CALCULATE(DISTINCTCOUNT('Table'[Item Code])))

File is attached.

Kind regards, Steve. 

[DjDon]

That works great - thanks!