Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Counting unique values in a column

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 Sp...
  • besomebody20's avatar
    besomebody20
    3 years ago

    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]))
besomebody20's avatar
besomebody20
Icon for Resolver I rankResolver I
3 years ago

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]))