Average of Count within a group

Question

Hi all,&nbsp;Im looking for a single measure I can place in a card that displays the average number of items in a group category.&nbsp;In the dataset below, I'd like the card to display 3 which is the average count of Item Codes per Office Location.&nbsp; Item codes are unique.&nbsp;Have tried several variants using GROUPBY but no success.&nbsp; Thanks for any help!&nbsp;&nbsp;Data&nbsp;Looking for overall average:Office Loc codeOfficeItem Code&nbsp;&nbsp;&nbsp;Avg ItemsOfficeAOffice location AA00025&nbsp;&nbsp;OfficeA4OfficeAOffice location AA00049&nbsp;&nbsp;OfficeB2OfficeAOffice location AA00073&nbsp;&nbsp;OfficeC3OfficeAOffice location AA00193&nbsp;&nbsp;Overall Average:3OfficeBOffice Location BA00313&nbsp;&nbsp;&nbsp;&nbsp;OfficeBOffice Location BA00385&nbsp;&nbsp;&nbsp;&nbsp;OfficeCOffice Location CA00409&nbsp;&nbsp;&nbsp;&nbsp;OfficeCOffice Location CA00481&nbsp;&nbsp;&nbsp;&nbsp;OfficeCOffice Location CA00505&nbsp;&nbsp;&nbsp;&nbsp;

stevedep · Accepted Answer

Hi,
&nbsp;
pls see below:
Measure = AVERAGEX(VALUES('Table'[Office]), CALCULATE(DISTINCTCOUNT('Table'[Item Code])))
File is attached.
Kind regards, Steve.&nbsp;

Forum Discussion

Average of Count within a group

2 Replies

Related content

Average - Distinct Count

Accumulated average

Average and Moving Average

Counting nulls

Average Count Per Day

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