Creating a list string with measure?

[marconimedeiros]

Hello folks,

I have a table column with some strings:

Saler 1

Saler 2

Saler 2

Saler 1

Saler 3

Is possible to create a measure to return the distincts values from the column? I want to plot in a matrix visual.

The results I need is:

Saler 1

Saler 2

Saler 3

Anyone can help me, please?

Thanks!

[OwenAuger · Accepted solution]

Hello @marconimedeiros

If you're wanting to create a measure that returns a concatenation of the column values (delimited by a linefeed character) as text, you can use CONCATENATEX.

Something like this works for me:

Concatenation Measure = 
CONCATENATEX (
    VALUES ( YourTable[YourColumn] ),
    YourTable[YourColumn],
    UNICHAR ( 10 ),
    YourTable[YourColumn]
)

VALUES could be replaced by DISTINCT if you want to exclude the blank value resulting from unmatched values on the many-side of a relationship.

Regards,

Owen