Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

how to count distinct values in a column

HI I have a column with 2 different text values in, and i need to create a measure that can make a distinct count of these 2 values I have see the following https://community.powerbi.com/t5/Desktop/CA...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    solved with the following

     

    CountItem = CALCULATE (
        DISTINCTCOUNT (TblName[itemnumber] );TblName[Status]="Open")

     

Framet's avatar
Framet
Icon for Resolver II rankResolver II
9 years ago

Hi,

 

Without seeing some example data this isn't all that clear. If you have two possible text values in a column then distinct count will only return 0,1,2 depending on your filters. Is this your desired result?

It might seem a bit obvious but does DISTINCTCOUNT([Your Column Name] return what you need?

Thanks

Thomas

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Thanks. I came to this post looking for help finding the number of distinct values in a column and the DISTINCTCOUNT function did work for me.