Mean and Count by category of a list

[antjos]

HI All, 

I have the following table which looks at attendance in a day and need to get summary value by Month. 

Jan 1	Tom
Jan 1	Jerry
Jan 1	Juan
Jan 1	Franco
Jan 1	Bugs
Jan 2	Tom
Jan 2	Jerry
Jan 3	Tom
Jan 3	Bugs
Jan 3	Tom
Feb 1	Tom
Feb 2	Bugs
Feb 2	Jerry
Feb 3	Franco
Feb 4	Juan

I want to count the number of people each day which I could achive by distinct count. 

However, I am struggling a bit to get 

Mean Attendance per Month (which would be mean of total attendance per day). I am currently using PowerPivot but i assume it is the same as PowerBI

[amitchandak · Accepted solution]

@antjos , You need to have measures like

Averagex( Values(Table[Date]), calculate(distinctcount(Table[Name])) )