cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ponchibonos
Regular Visitor

agrupar bajo un mismo ID

Hola a todos en el foro.

 

He preparado esta tabla ordenada por ID de los ponentes que participaron en unas reuniones.

 

Lo que necesito hacer es colocar una tarjeta que ponga el número de personas asistentes y visualizaciones por sesión.  He buscado varias opciones y suma el número de asistentes y visualizaciones.  Lo que necesitaría es saber que función usar para que los agrupe y considere como un grupo a todos los de la IDSesion 1, ID Sesión 2....

 

ponchibonos_0-1605372887912.png

 

 

Saludos

1 ACCEPTED SOLUTION

@ponchibonos

The problem is that the data table collects the total of attendees and visualizations in each row. To fix this, you must first create a measure that is the average of attendees and the average of visualizations.

Asistentes por sesión = AVERAGE(TablaDatos[Asistentes])
Visualizaciones por sesión = AVERAGE(TablaDatos[Visualizaciones])

Here's an image of how I created the data model, because for sum measurement and visualizations, I use the DIM tables you'll see:

Modelo.JPG

The sum of visualizations is done with the SUMX function:

Suma Asistentes = SUMX('DIM ID Sesión', [Asistentes por sesión])
Suma Visualizaciones = SUMX('DIM ID Sesión', [Visualizaciones por sesión])

And with these sum measures, you can create visualizations:

Unfiltered example:

Totales.JPG

Example by filtering session 1:

Sesión 1.JPG

I attach the PBIX file so you can see the development.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

3 REPLIES 3
ponchibonos
Regular Visitor

@PaulDBrown

Thank you for your response.

What I need is to have a card in PowerBi that presents the data of all attendees at 4 sessions (Session ID1 +Session ID2 + Session ID3 +Session ID4 x 3325) and what the program does is it sums all the records for a total of 17,707. I would also like that when I select in some visualization or graph, where session 1 is selected, the card will be updated and presented to me the attendees of session 1 (1,082).

I hope I do clearly in my explanation.

Best regards

Session IDID SpeakerGenderSubjectDateCountryRegionAssistantsViews
11ManEnergyTuesday, February 18, 2020MexicoMexico City481082
12ManEnergyTuesday, February 18, 2020MexicoMexico City481082
13WomanEnergyTuesday, February 18, 2020MexicoMexico City481082
14WomanEnergyTuesday, February 18, 2020MexicoMexico City481082
15ManEnergyTuesday, February 18, 2020MexicoMexico City481082
16ManEnergyTuesday, February 18, 2020MexicoMexico City481082
27ManField and foodThursday, March 5, 2020MexicoYucatan62501
28ManField and foodThursday, March 5, 2020MexicoMexico City62501
29WomanField and foodThursday, March 5, 2020MexicoMexico City62501
210WomanField and foodThursday, March 5, 2020MexicoMexico City62501
211WomanField and foodThursday, March 5, 2020MexicoMexico City62501
312ManField and foodTuesday, May 26, 2020MexicoMexico City46417
313ManField and foodTuesday, May 26, 2020MexicoMexico City46417
314WomanField and foodTuesday, May 26, 2020MexicoMexico City46417
315ManField and foodTuesday, May 26, 2020MexicoMexico City46417
316ManField and foodTuesday, May 26, 2020MexicoMexico City46417
417ManEnergyThursday, June 4, 2020MexicoYucatan1251325
418ManEnergyThursday, June 4, 2020MexicoMexico City1251325
419WomanEnergyThursday, June 4, 2020MexicoMexico City1251325
420ManEnergyThursday, June 4, 2020MexicoMexico City1251325
421WomanEnergyThursday, June 4, 2020MexicoPuebla1251325

@ponchibonos

The problem is that the data table collects the total of attendees and visualizations in each row. To fix this, you must first create a measure that is the average of attendees and the average of visualizations.

Asistentes por sesión = AVERAGE(TablaDatos[Asistentes])
Visualizaciones por sesión = AVERAGE(TablaDatos[Visualizaciones])

Here's an image of how I created the data model, because for sum measurement and visualizations, I use the DIM tables you'll see:

Modelo.JPG

The sum of visualizations is done with the SUMX function:

Suma Asistentes = SUMX('DIM ID Sesión', [Asistentes por sesión])
Suma Visualizaciones = SUMX('DIM ID Sesión', [Visualizaciones por sesión])

And with these sum measures, you can create visualizations:

Unfiltered example:

Totales.JPG

Example by filtering session 1:

Sesión 1.JPG

I attach the PBIX file so you can see the development.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






View solution in original post

PaulDBrown
Super User II
Super User II

@ponchibonos 

 

Podrías por favor incluir una muestra de la tabla de datos (pero en formato datos, no imagen) y una representación gráfica de lo que quieres conseguir? (un ejemplo gráfico hecho en Excel por ejemplo)

Gracias.





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.