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

[GettingStarted]

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	email
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!

[some_bih]

Hi @GettingStarted try: 

Count non blank rrows= 

  CALCULATE(

        COUNTROWS(Sheet19),

        Sheet19[   email]<>"null"

    )

Adjust Sheet 19 to your table name. I hope this help

[GettingStarted]

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...

[tamerj1]

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