Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Power BI count email addresses where some are duplicate and some are blank

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.

number      email

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!
Memorable Member
Memorable Member

Hi @GettingStarted try: 

Count non blank rrows= 
        Sheet19[   email]<>"null"
Adjust Sheet 19 to your table name. I hope this help
Sarajevo, Bosnia and Herzegovina

Thanks for your help, I really appreciate it.
It still doesn't seem to be working as it's only counting the unique value.


Total Emails = CALCULATE(
        table[email] <>"null"

returns a value of 1 instead of 3. It's weird so maybe there is something I'm overlooking...

Hi @GettingStarted 
Even the COUNTX approach should work. Definitely there is is something that is being overlooked.

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors