How to measure a average of the count rows?

[Anonymous]

Hi guys,

I have the following table

ExaminationID          Req_id

233313                      1

233455                      1

233123                      1

333421                      1

445531                      2

234553                      2

993030                      2

837782                      3

474875                      3

677793                      4

currently i have a measure that count the examinationId per Req_id (=COUNT(ExaminationID). With this measure i can show for example that req_id have 4 examinations and req_id has 3 examinations and so  on.....

Now i need your help how to make a measure that gives a average of the counted rows.  Which formula should i use?

Thanks for your help!

[v-shex-msft · Accepted solution]

Hi @Anonymous,

You can try to use 'summarize' function to summary count of 'examinationid', then use 'averagex' function to calculate on this new column.

Sample:

Measure = AVERAGEX(SUMMARIZE('sample',[Req_id],"Count",COUNT('sample'[ExaminationID])),[Count])

Regards,

Xiaoxin Sheng

[Greg_Deckler]

I may be completely off-base with this, but the average of the counts should equal the average of it all together.

If I have 10 rows and 4 unique things, then the average is always going to be 2.5. 

Since the average is always just the sum divided by the number of items, then since you are just counting rows you would just take the count of ALL divided by the distinct count of the req_id.