Sorting a calculated measure in descending order. All values stored as text in a measure.

[JCERVANTES]

I'm struggling with sorting a concatenated text value stored in a measure. I have a table of data used for voting statistics. One requirement that I'm dealing with is taking vote totals and displaying them in a concatenated string. The results are as shown...

I've acheived this view using the following DAX:

VAR DistinctValues = DISTINCT('Supply Chain Committee Votes Details'[VoteChoice])

VAR ValueCounts =

    ADDCOLUMNS(

        DistinctValues,

        "Count",

        CALCULATE(COUNTROWS('Supply Chain Committee Votes Details'), FILTER('Supply Chain Committee Votes Details', 'Supply Chain Committee Votes Details'[VoteChoice]= EARLIER('Supply Chain Committee Votes Details'[VoteChoice])))

    )

RETURN

    CONCATENATEX(

        ValueCounts,

        FORMAT([Count], "(#)") & " " & 'Supply Chain Committee Votes Details'[VoteChoice] & " ", " ", " "

    )

The part of struggling with now, is sorting the result in descending order from left to right. I had "high" hopes that it would sort natively (that's just me asking for too much). I've tried just about every function, even trying to create a new column except the results I'm looking for are not panning out.

 Anyone have any ideas? Can't seem to wrap my head around it. Unfortunately I cannot supply any data samples

[JCERVANTES]

Thank you! That worked. I see where I was going wrong.

[AlexisOlson · Accepted solution]

Try using the order by argment in CONCATENATEX.

I think it works like this:

VAR ValueCounts =
    SUMMARIZE (
        'Supply Chain Committee Votes Details',
        'Supply Chain Committee Votes Details'[VoteChoice],
        "@Count", COUNTROWS ( 'Supply Chain Committee Votes Details' )
    )
RETURN
    CONCATENATEX (
        ValueCounts,
        FORMAT ( [@Count], "(#) " ) & 'Supply Chain Committee Votes Details'[VoteChoice],
        " ",
        [@Count], DESC
    )