Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 |
Solved! Go to 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 , 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])))
Thank you. It is working perfectly. Is there a way blank or null can be replaced by 0 in my tables?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |