Forum Discussion

adityavighne's avatar
adityavighne
Icon for Continued Contributor rankContinued Contributor
7 years ago

Text count number shows with comma

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

Data Modeling
Reports

5 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    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 

      • v-qiuyu-msft's avatar
        v-qiuyu-msft
        Icon for Community Support rankCommunity Support
        7 years ago

        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