Count and Group by - Urgent help

[kh0050]

This is my data, I want to prepare a report to show the number of students accesses to the course. I have a day access a data field which I can use to count the number of days access to the course by each student and if I use Group by it will count the blank or null value in the table. How can I avoid counting blank or null and also display 0 for null or blank in the table?

User ID    Day Access

kh0060	12-Apr-21
kh0071	12-Apr-21
kh0060	04-Mar-21
kh0089	04-Mar-21
kh0060	03-Mar-21
kh0089	06-Mar-21
kh0071	29-Mar-21
kh0060	28-Mar-21
kh0071	28-Mar-21
kh0060	31-Mar-21
kh0060
kh0071
kh0089

[amitchandak · Accepted solution]

@kh0050 , usally when count, it should not count blank

count(Table[Day Access])

or can create like

calculate(count(Table[Day Access]), not(isblank(Table[Day Access])))

[kh0050]

Thank you. It is working perfectly. Is there a way blank or null can be replaced by 0 in my tables?