Forum Discussion

nwabramson's avatar
nwabramson
Advocate III
9 years ago
Solved

format 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. 
Need Help
  • Vvelarde's avatar
    Vvelarde
    9 years ago

    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's avatar
nwabramson
Advocate III
9 years ago

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's avatar
Vvelarde
Community Champion
9 years ago

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's avatar
    nwabramson
    Advocate III
    9 years ago

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