DAX to concatenate multiple measure values with newlines into single measure

[Anonymous]

So I can't seem to find an answer to this anywhere... I have a series of measure that are reading the selected values of different slicers. I'd like to take these measures and combine them into a new single measure that separates their values with newlines. Here is a sketch of what I want to do:

HAVE:

measure_2 = "slicer value a; slicer value b; slicer value c"

measure_2 = "slicer value e; slicer value f; slicer value g"

measure_3 = "slicer value x; slicer value y; slicer value z"

WANT:

measure_4 = "measure_1: slicer value a; slicer value b; slicer value c

                       measure_2: slicer value e; slicer value f; slicer value g

                       measure_3: slicer value x; slicer value y; slicer value z"

Is there any possible way to do this? I think the CONCATENATEX function will probably be involved but I'm honestly pretty stuck. Thank you!
 

[amitchandak · Accepted solution]

@Anonymous , try like

"Slicer a " & CONCATENATEX(values(Table[slicer value a]),Table[slicer value a]) & "Slicer b " & CONCATENATEX(values(Table[slicer value b]),Table[slicer value b]) & "Slicer b "
& CONCATENATEX(values(Table[slicer value c]),Table[slicer value c])

[harshnathani]

Hi @Anonymous ,

Can you share a screenshot of your current scenario and what are the expected results.

Regards,

HN