Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
JJ
Solved! Go to Solution.
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
Fantastic, working now. thank you
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
User | Count |
---|---|
47 | |
26 | |
22 | |
17 | |
15 |
User | Count |
---|---|
55 | |
34 | |
18 | |
17 | |
15 |