topic Re: Dynamic Order in Title in DAX Commands and Tips

Dynamic Order in Title

DW868990 — Fri, 23 Sep 2022 11:14:13 GMT

Hi,

I have a dynamic title that shows up to 6 responses per end user selection. The selection is made via a slicer of table like below.

Now i have used CONCATENATEX within the measure of the title so it does show the end user selections, but I need it to show in order of the ranking column above. It seems CONCATENATEX can only be ordered by a measure, not a column, or am i missing something? Thanks in advance.

Re: Dynamic Order in Title

lbendlin — Sat, 24 Sep 2022 22:24:11 GMT

works for me

You probably forgot to specify that you want to sort "Response" by "Ranking"

Re: Dynamic Order in Title

Anonymous — Mon, 26 Sep 2022 08:12:29 GMT

Hi DW868990 ,

You can create a measure as below to get it by using CONCATENATEX function , please find the details in the attachment.

Title = CONCATENATEX ( ALLSELECTED ( 'Table' ), 'Table'[Response], ",", 'Table'[Ranking], ASC )

Best Regards

Re: Dynamic Order in Title

DW868990 — Mon, 26 Sep 2022 09:13:42 GMT

Fantastic, working now. thank you