Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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:
Hi @GettingStarted try:
Proud to be a Super User!
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
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.
User | Count |
---|---|
13 | |
8 | |
8 | |
7 | |
5 |
User | Count |
---|---|
21 | |
15 | |
15 | |
10 | |
7 |