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/CALCULATE-count-of-several-text-values/m-p/33878/highlight/false#M12112 But this is counting all the rows. I have tried to change it a bit, but no success
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    solved with the following

     

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

     

6 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    solved with the following

     

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

     

    • MAAbdullah47's avatar
      MAAbdullah47
      Icon for Helper V rankHelper V
      9 years ago

      This work with me In measure (correct value) but On column, it gives a wrong value , why ?

    • gusdahu's avatar
      gusdahu
      Icon for Helper IV rankHelper IV
      7 years ago

      Hi Anonymous ,

       

      I used the same DAX you posted, however I received a result of one when it should've been two. What am I doing incorrectly? Here is my DAX expression:

       

      Count Words = CALCULATE(DISTINCTCOUNT(Sheet1[Description]),Sheet1[Description]="Gloves")
       
      Regards,
      Gus Dahu

       


       

  • 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Worked perfectly! Thank you so much!