topic Sorting a calculated measure in descending order. All values stored as text in a measure. in DAX Commands and Tips

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

Anonymous — Wed, 12 Feb 2025 17:17:23 GMT

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

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

AlexisOlson — Wed, 12 Feb 2025 21:25:12 GMT

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 )

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

Anonymous — Thu, 13 Feb 2025 15:18:55 GMT

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