Text count number shows with comma

[adityavighne]

Hi,

I want to distinctcount of 8999294758_4748747 which is in text format.

now this distinctcount display I want to be separated with comma eg. final count is 3991 so I want 3,991 in this format

when I convert this text to the whole number this gives an error any other solution DAX

[v-qiuyu-msft]

Hi @adityavighne ,

The value of Distinctcount() function should be number. It looks like you used Format function to force thousands separator for the distinct count value, right? 

Please keep the DAX of distinctcount only, at this time, the returned values are numbers. Then select the measure/column then enable Thousands Separator. 

Best Regards,
Qiuyun Yu 

[adityavighne]

Thanks for the reply. 

[v-qiuyu-msft]

Hi @adityavighne,

If my reply is helpful for you to resolve the issue, would you please mark a helpful reply as an answer so we can close this thread? 

Best Regards,
Qiuyun Yu 

[adityavighne]

Thanks for the reply.

This was not what I want. 

I solved this creating measure of the same column and then using ( , ) formatting for values and it's working.

Thank you!

Regards,

Aditya 

[Anonymous]

Hi adityavighne ,

Could you please tell me how you resolved this issue.

Thanks

Preetham