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 DISTINCTCOUNT(ProductName).It is returning 1 instead of 3.

 

Can anyone assist me in solving this issue ?

 

Regards,

Priya

 

Need Help

3 Replies

  • Vvelarde's avatar
    Vvelarde
    Icon for Community Champion rankCommunity 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
        Icon for Microsoft Employee rankMicrosoft 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