topic Re: DAX to concatenate multiple measure values with newlines into single measure in DAX Commands and Tips

DAX to concatenate multiple measure values with newlines into single measure

Anonymous — Tue, 14 Jul 2020 19:11:23 GMT

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!

Re: DAX to concatenate multiple measure values with newlines into single measure

Anonymous — Tue, 14 Jul 2020 19:23:14 GMT

Hi Anonymous ,

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

Regards,

Re: DAX to concatenate multiple measure values with newlines into single measure

amitchandak — Wed, 15 Jul 2020 06:40:01 GMT

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])