How to use a list of values from a field and visualize as a single text by a comma separator?

[Anonymous]

Hello dear experts, 

I'm having a column with Owners as shown below, and in the end I would like to visualize this as "A, B, C, D" in a single card.

Please suggest how do I achieve this?

Kind regards,

Ambareesh.

[nandukrishnavs · Accepted solution]

@Anonymous 

Write a DAX measure

Measure = CONCATENATEX('Table','Table'[Owners],",")

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[harshnathani · Accepted solution]

Hi @Anonymous 

Create a measure

MEASURE = CoNCATENATEX ('Table','Table'[Owner],",")

Incase you want separate Line

MEASURE = CoNCATENATEX ('Table','Table'[Owner],UNICHAR(10))

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[harshnathani · Accepted solution]

Hi @Anonymous 

Create a measure

MEASURE = CoNCATENATEX ('Table','Table'[Owner],",")

Incase you want separate Line

MEASURE = CoNCATENATEX ('Table','Table'[Owner],UNICHAR(10))

Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)

[Anonymous]

Hi @harshnathani 

Yes almost there, but what if I have duplicates like A, A, B, C, D in the entire list of owners, but I wish to see only A,B,C,D?

Thanks for your quick response. 

[Anonymous]

So I found the answer to the duplicates too.

CALCULATE(CONCATENATEX(VALUES(Owner), Owner, ", "))

Thank you all for your prompt responses. 

[nandukrishnavs · Accepted solution]

@Anonymous 

You could try this DAX

Measure = CONCATENATEX(DISTINCT('Table'[Owners]),'Table'[Owners],",")

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂

[nandukrishnavs · Accepted solution]

@Anonymous 

Write a DAX measure

Measure = CONCATENATEX('Table','Table'[Owners],",")

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂