Counting unique values in a column

[Anonymous]

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
Facebook	Spain	Data Analyst
ARM	Ireland	Data Analyst
Intel	UK	Data Analyst
Google	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!

[v-yadongf-msft]

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

[besomebody20 · Accepted 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]))