Measure to concat by distinct company name

[FatBlackCat30]

I am trying to create a measure that will concatenate the salesmembers by company, with each salesmember being on a new line. I did this with calculated columns but the issue I ran into was if I used my salesmember slicer and sliced to Noelle for example this would come up:

Mcdonalds

Noelle Ryan Danny

I want to isolate the salesmembers when I slice to a specific person since each person has other specific roles with the company

Before
Company	salesmember
Mcdonalds	Noelle
Mcdonalds	Ryan
Mcdonalds	Danny
Target	Vinnie
Target	Dennis
Target	Red
Target	Raven
Walmart	Colby
Walmart	Felix
Walmart	Nathan
Walmart	Carol
Fred Myers	Joan
Winco	Ty

After
Company	Salesmember
Mcdonalds	Noelle Ryan Danny
Target	Vinnie Dennis Red Raven
Walmart	Colby Felix Nathan Carol
Fred Myers	Joan
Winco	Ty

[amitchandak]

Create a measure using concatenatex

https://docs.microsoft.com/en-us/dax/concatenatex-function-dax

concat salesperson=concatenatex(table,table[salesperson], UNICHAR(10))

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin

[FatBlackCat30]

I tried this but it does not work

concat salesperson=concatenatex(distinct(table),table[salesperson], UNICHAR(10))

[FatBlackCat30]

thanks,

where would I add the distinct to not repeat the salesmembers? 

[amitchandak · Accepted solution]

You can visualize using a table or a matrix. by choosing the company and the new measures. For distinct try

concat salesperson=concatenatex(distinct(table[salesperson]),table[salesperson], UNICHAR(10))

[FatBlackCat30]

that was it, thanks for the help