DistinctCount of Text values

[priyapalanki]

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

[Vvelarde · Accepted solution]

@priyapalanki

Hi, with your data DistinctCount return 3. 

Did you have a filter applied?

[priyapalanki]

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

[v-huizhn-msft]

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