Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hola a todos,
Tengo una mesa
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 | Azufre |
Intenté usar tanto table Visual como Matrix Visual
Pero no se puede mostrar todo en una columna como abajo
ahora necesito mostrar todas las comunidades en una sola columna
Circuit_Name | CommunityName |
ARDMORE 24 | Ardmore,Marietta,Stratford,Sulphur |
Solved! Go to Solution.
Hola @rasala583 - esta medida debería funcionar para usted:
Communities =
CONCATENATEX (
SUMMARIZE ( Circuits, Circuits[Circuit_Name], Circuits[CommunityName] ),
Circuits[CommunityName],
","
)
Espero que esto ayude
David
Hola
Prueba esta medida
=CONCATENATEX(
VALUES(Data[Community Name]),
Data[Community Name],
","
)
Hope this helps.
Hola @rasala583 - esta medida debería funcionar para usted:
Communities =
CONCATENATEX (
SUMMARIZE ( Circuits, Circuits[Circuit_Name], Circuits[CommunityName] ),
Circuits[CommunityName],
","
)
Espero que esto ayude
David