how to show multiple row values in once column

[Anonymous]

Hello All,

I have a table with circuit and Communities 

i used both table visual and Matric visual

but not able to show how they wanted it to be seen 

they wanted to see the all the communities in one column like shown in below table 

circuit	Communities
ADABELL ROAD 24	ALma, Fort Smith, Van Buren

[parry2k]

@Anonymous create a measure to concatenate

Measure = 
CONCATENATE ( Table, Table[CommunityName], "," )

IN visual, use circuit name, and above measure.

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

[Anonymous]

Thanks for the Idea but i already tried that 

the main issue is i have multiple Community names 

CONTRACT_ACCOUNT_NUMBER	Circuit_Name	CommunityName
128979804	ARDMORE 26	Ardmore
129597277	ARDMORE 26	Ardmore
382053	ARDMORE 26	Ardmore
130312913	ARDMORE 26	Ardmore
129309056	ARDMORE 26	Ardmore
131547769	ARDMORE 26	Ardmore
131404208	ARDMORE 26	Fox
129120672	ARDMORE 26	Wilson
127785497	ARDMORE 26	Kingston

so if i do concatenate then this is what i am getting which we don’t need we want only the distinct communities

CONTRACT_ACCOUNT_NUMBER	Circuit_Name	CommunityName
128979804	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
129597277	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
382053	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
130312913	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
129309056	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
131547769	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
131404208	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
129120672	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston
127785497	ARDMORE 26	Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Ardmore,Fox,Wilson,Kingston

[Ashish_Mathur]

Hi,

Confusing requirement.  In your original question, you did not have Contract Account but in this post you do.  Share the exact expected result.

[mahoneypat · Accepted solution]

Please try this expression

Community Names = CONCATENATEX(VALUES(Table[CommunityName]), Table[CommunityName], ", ")

If this works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.

Regards,

Pat

[parry2k]

@Anonymous @mahoneypat solution will work but you have to have only circuit name and measure in the visual, not all the columns.

[Greg_Deckler]

@Anonymous You could use a matrix and put Community in Columns. Or, create a measure that uses CONCATENATEX to munge all of the communities together.