Forum Discussion
ConcatenateX with text and counts
Hello all, I have a need to create a Concatenated list with Counts and Values. I can get the unique values through ConcatenateX, but I want to add the count of the number of times they appear....
Try this:
Measure = VAR __Table = SUMMARIZE( 'Table', [Status], "Count",COUNTROWS('Table') ) RETURN CONCATENATEX(__Table,[Count] & " " & [Status],", ")
Greg_Deckler
Community Champion
Community ChampionTry this:
Measure =
VAR __Table =
SUMMARIZE(
'Table',
[Status],
"Count",COUNTROWS('Table')
)
RETURN
CONCATENATEX(__Table,[Count] & " " & [Status],", ")Brilliant! Thank you!
- Greg_DecklerApparently that worked then? 🙂