Forum Discussion
nwabramson
Advocate III
Advocate IIIformat distinct count
Is there a way to format the numeric result of an aggregation such as distinct count? I would like to add commas to my results and can't figure out how to display.
A way yo solve your problem is:
If is only one value to show you can use a Card Visual. (In formatting Options you can made the changes to show the ,)
or Create a a measure to made the Distinct Count
Carrier-DC=DistinctCount(Table[Carrier]) And Formatting this measure (In modeling)
nwabramsonAdvocate III
Advocate IIIHow do I model for a text field that I am creating a distinct count? I can't seem to figure it out for aggregates.
Westcoaster
Advocate I
Advocate IIf you go to the formating options and look at the Data label field. If you change the Display units to 'None' and the Value decimal places from Auto to 0 then the 1000 comma separator is shown in the result. Found this by accident.