How to show all the column values in a single row per Circuit Name

[Anonymous]

Hello All, 

i have a table 

Circuit_Name	CONTRACT_ACCOUNT_NUMBER	CommunityName
ARDMORE 24	322382	Ardmore
ARDMORE 24	322385	Ardmore
ARDMORE 24	322391	Ardmore
ARDMORE 24	322395	Ardmore
ARDMORE 24	322400	Ardmore
ARDMORE 24	131599652	Ardmore
ARDMORE 24	131600759	Ardmore
ARDMORE 24	131601250	Ardmore
ARDMORE 24	131601585	Ardmore
ARDMORE 24	2000764	Marietta
ARDMORE 24	127716387	Marietta
ARDMORE 24	128010672	Marietta
ARDMORE 24	128226326	Marietta
ARDMORE 24	128355644	Marietta
ARDMORE 24	128566177	Marietta
ARDMORE 24	128842562	Marietta
ARDMORE 24	128958608	Marietta
ARDMORE 24	129765752	Marietta
ARDMORE 24	131003296	Marietta
ARDMORE 24	131113786	Marietta
ARDMORE 24	131136092	Marietta
ARDMORE 24	131145499	Marietta
ARDMORE 24	131491299	Marietta
ARDMORE 24	129488236	Stratford
ARDMORE 24	130928636	Sulphur

I tried using both the Table Visual and Matrix Visual

But unable to show everything in one column like below 

now i need to show all the communities in a one column 

Circuit_Name	CommunityName
ARDMORE 24	Ardmore,Marietta,Stratford,Sulphur

[Ashish_Mathur]

Hi,

Try this measure

=CONCATENATEX(VALUES(Data[Community Name]),Data[Community Name],",")

Hope this helps.

[dedelman_clng · Accepted solution]

Hi @Anonymous - this measure should work for you:

Communities =
CONCATENATEX (
    SUMMARIZE ( Circuits, Circuits[Circuit_Name], Circuits[CommunityName] ),
    Circuits[CommunityName],
    ","
)

Hope this helps

David