The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 |
---|---|
27 | |
12 | |
8 | |
7 | |
5 |
User | Count |
---|---|
31 | |
15 | |
12 | |
7 | |
6 |