cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kh0050
Frequent Visitor

Count and Group by - Urgent help

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

kh006012-Apr-21
kh007112-Apr-21
kh006004-Mar-21
kh008904-Mar-21
kh006003-Mar-21
kh008906-Mar-21
kh007129-Mar-21
kh006028-Mar-21
kh007128-Mar-21
kh006031-Mar-21
kh0060 
kh0071 
kh0089 
1 ACCEPTED SOLUTION
amitchandak
Super User IV
Super User IV

@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])))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

2 REPLIES 2
amitchandak
Super User IV
Super User IV

@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])))



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

View solution in original post

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors