Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Power BI count email addresses where some are duplicate and some are blank
06-08-2023
09:45 PM
Hi all,
It would be awesome if I could get some help with this as I'm quite new to Power BI. I'm trying to count email addresses if they are not blank/null but I don't know how to get the correct result.
Example:
number | |
1234 | 123@email.com |
5678 | 123@email.com |
1213 | 123@email.com |
1415 | null |
1617 | xyz@email.com |
My measure is:
Count Email = COUNTX (table1, [email])
This results in a total of 2 email addresses but I need it to be 4. I'm not sure why this is so hard for me haha. Any help is greatly appreciated if possible. Thanks!
This results in a total of 2 email addresses but I need it to be 4. I'm not sure why this is so hard for me haha. Any help is greatly appreciated if possible. Thanks!
3 REPLIES 3
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023
10:46 PM
Hi @GettingStarted try:
Count non blank rrows=
COUNTROWS(Sheet19),
Sheet19[ email]<>"null"
)
Adjust Sheet 19 to your table name. I hope this help
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023
11:06 PM
Thanks for your help, I really appreciate it.
It still doesn't seem to be working as it's only counting the unique value.
123@email.com
123@email.com
123@email.com
Total Emails = CALCULATE(
COUNTROWS(table),
table[email] <>"null"
)
returns a value of 1 instead of 3. It's weird so maybe there is something I'm overlooking...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-08-2023
11:22 PM
Hi @GettingStarted
Even the COUNTX approach should work. Definitely there is is something that is being overlooked.

Helpful resources
Announcements
Power BI Monthly Update - July 2025
Check out the July 2025 Power BI update to learn about new features.

Top Solution Authors (Last Month)
User | Count |
---|---|
24 | |
10 | |
6 | |
6 | |
6 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
29 | |
11 | |
11 | |
10 | |
6 |