Count Rows with Multiple Criteria using Date and ID

[Anonymous]

Hi All,

Wondering if you can help me. I am tasked to produce monthly Staff Attendance reports to make sure staff are coming back into the office after the pandemic. 

I want to create a column that counts the number of rows where they attend each month. 

So my conditions are number of times in a month and their employee reference number. 

I'm trying to use Count and Filter but this is counting total rows in table. In the below example I should have 2 in Count rows (Month) column as this staff member tapped in twice in May.

[Anonymous · Accepted solution]

I managed to fix this issue by creaating an aggregated table and then doing a count on Emp ID and filter on month. 

[NickolajJessen]

Firstly, don't do this in a calculated column. Do it in a measure.
Secondly i'm a bit confused about the redacted table names. Are they a secret?

[Anonymous]

Hi Nickolaj, 

The reason I want to do it in a column is I then want to bring it into a calculated table to then do a further calcultion on days attended each month divided by number of available days.

So for me I attended the office 4 times this month and 22 days available in the month so that will be 18% time in office in that month. 

I redacted the table names as it shows the place names of where I work. I'd rather not show you that.

Thanks for your help. I really, really appreciate it.