Forum Discussion

marconimedeiros's avatar
marconimedeiros
Frequent Visitor
7 years ago
Solved

Creating a list string with measure?

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's avatar
    OwenAuger
    7 years ago

    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

1 Reply

  • OwenAuger's avatar
    OwenAuger
    Super User
    7 years ago

    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