Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Cómo mostrar todos los valores de columna en una sola fila por nombre de circuito

Hola a todos,

Tengo una mesa

Circuit_NameCONTRACT_ACCOUNT_NUMBERCommunityName
ARDMORE 24322382Ardmore
ARDMORE 24322385Ardmore
ARDMORE 24322391Ardmore
ARDMORE 24322395Ardmore
ARDMORE 24322400Ardmore
ARDMORE 24131599652Ardmore
ARDMORE 24131600759Ardmore
ARDMORE 24131601250Ardmore
ARDMORE 24131601585Ardmore
ARDMORE 242000764Marietta
ARDMORE 24127716387Marietta
ARDMORE 24128010672Marietta
ARDMORE 24128226326Marietta
ARDMORE 24128355644Marietta
ARDMORE 24128566177Marietta
ARDMORE 24128842562Marietta
ARDMORE 24128958608Marietta
ARDMORE 24129765752Marietta
ARDMORE 24131003296Marietta
ARDMORE 24131113786Marietta
ARDMORE 24131136092Marietta
ARDMORE 24131145499Marietta
ARDMORE 24131491299Marietta
ARDMORE 24129488236Stratford
ARDMORE 24130928636

Azufre

Intenté usar tanto table Visual como Matrix Visual

Test_Image.PNG

Pero no se puede mostrar todo en una columna como abajo

ahora necesito mostrar todas las comunidades en una sola columna

Circuit_NameCommunityName
ARDMORE 24Ardmore,Marietta,Stratford,Sulphur
1 ACCEPTED SOLUTION
dedelman_clng
Community Champion
Community Champion

Hola @rasala583 - esta medida debería funcionar para usted:

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

2020-08-10 16_18_27-N_and_BASE_problem (3) - Power BI Desktop.png

Espero que esto ayude

David

View solution in original post

2 REPLIES 2
Ashish_Mathur
Super User
Super User

Hola

Prueba esta medida

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

Hope this helps.


Regards,
Ashish Mathur
http://www.ashishmathur.com
https://www.linkedin.com/in/excelenthusiasts/
dedelman_clng
Community Champion
Community Champion

Hola @rasala583 - esta medida debería funcionar para usted:

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

2020-08-10 16_18_27-N_and_BASE_problem (3) - Power BI Desktop.png

Espero que esto ayude

David

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors