Forum Discussion

priyapalanki's avatar
priyapalanki
Frequent Visitor
9 years ago
Solved

DistinctCount of Text values

Hi ,   I have trouble using DISTINCTCOUNT on a column of datatype 'Text' .  Say I have column "ProductName' with below values.   Facebook Netflix Facebook Netflix Kodi   I created a measure...
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    priyapalanki

     

    Hi, with your data DistinctCount return 3. 

     

    Did you have a filter applied?

     

Vvelarde's avatar
Vvelarde
Community Champion
9 years ago

priyapalanki

 

Hi, with your data DistinctCount return 3. 

 

Did you have a filter applied?

 

  • priyapalanki's avatar
    priyapalanki
    Frequent Visitor
    9 years ago

    Thanks , this issue is resolved after I remove the filter.

     

     

     

     

    • v-huizhn-msft's avatar
      v-huizhn-msft
      Microsoft Employee
      9 years ago

      Hi priyapalanki,

      I am every glad you have resolve your issue, please mark the corresponding reply as answer, which will help other people find the solution easily and clearly. Thanks a lot.

       

      Best Regards,
      Angelia