Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi all,
Looking for help with something that I thought would be quite simple, but doesn't appear to be working for me.
I have the below table:
COMPANY | LOCATION | JOB TITLE |
Apple | Spain | Data Analyst |
Microsoft | France | Software Dev |
Spain | Data Analyst | |
ARM | Ireland | Data Analyst |
Intel | UK | Data Analyst |
USA | CEO | |
Amazon | Japan | COO |
I would like to get a distinct count of the number of companies and the number of locations, ie the number of times each one appears at least once. In the case of location it would be 6, for company it would be 7.
I thought I could do this using DISTINCTCOUNT() or COUNTROWS(DISTINCT()) but neither are working for me. Would anyone have any suggestions?
Thanks!
Solved! Go to Solution.
Hi @Anonymous ,
Here are a couple of measures you can try
Distinct Count that will include BLANK rows
Company Distinct Count = COUNTROWS(VALUES('Table'[COMPANY]))
Distinct Count that will exclude BLANK rows
Company Distinct Count = COUNTROWS(ALLNOBLANKROW('Table'[COMPANY]))
Hi @Anonymous ,
Has your problem been solved? If solved, please consider Accept it as the solution to help the other members find it more quickly.
Best regards,
Yadong Fang
Hi @Anonymous ,
Here are a couple of measures you can try
Distinct Count that will include BLANK rows
Company Distinct Count = COUNTROWS(VALUES('Table'[COMPANY]))
Distinct Count that will exclude BLANK rows
Company Distinct Count = COUNTROWS(ALLNOBLANKROW('Table'[COMPANY]))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
46 | |
22 | |
20 | |
15 | |
13 |
User | Count |
---|---|
49 | |
41 | |
39 | |
19 | |
19 |