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

     

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