Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to Solution.
Hi @Anonymous - this measure should work for you:
Communities =
CONCATENATEX (
SUMMARIZE ( Circuits, Circuits[Circuit_Name], Circuits[CommunityName] ),
Circuits[CommunityName],
","
)
Hope this helps
David
Hi,
Try this measure
=CONCATENATEX(
VALUES(Data[Community Name]),
Data[Community Name],
","
)
Hope this helps.
Hi @Anonymous - this measure should work for you:
Communities =
CONCATENATEX (
SUMMARIZE ( Circuits, Circuits[Circuit_Name], Circuits[CommunityName] ),
Circuits[CommunityName],
","
)
Hope this helps
David
User | Count |
---|---|
85 | |
75 | |
71 | |
69 | |
55 |
User | Count |
---|---|
98 | |
96 | |
92 | |
78 | |
70 |