format distinct count

[nwabramson]

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. 

[Vvelarde]

@nwabramson

Hi, you can model your field, column or measure going to Modeling Section:

[nwabramson]

How 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]

If you go to the Data Label in the formatting, you can change the display units to none and the value decimal places to 0 the 1,000 comma appears in the result.

[Westcoaster]

If 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.

[Sean]

Take a look here

https://msdn.microsoft.com/en-us/library/ee634924.aspx

just be aware FORMAT converts everything to text

[nwabramson]

Hello - I do not know how to use the format command with a table that shows a distinct count of a text field.  I can't use the modeling format here either. I would like it to display 1,362 instead of 1362 .

[Vvelarde · Accepted solution]

@nwabramson

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)

[nwabramson]

Thanks! That sounds like either way would solve my problem! Nancy.