Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
Thanks for the reply.
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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
75 | |
73 | |
49 |
User | Count |
---|---|
146 | |
108 | |
106 | |
90 | |
62 |