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.
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....
Saludos
Solved! Go to Solution.
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:
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:
Example by filtering session 1:
I attach the PBIX file so you can see the development.
Proud to be a Super User!
Paul on Linkedin.
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 ID | ID Speaker | Gender | Subject | Date | Country | Region | Assistants | Views |
1 | 1 | Man | Energy | Tuesday, February 18, 2020 | Mexico | Mexico City | 48 | 1082 |
1 | 2 | Man | Energy | Tuesday, February 18, 2020 | Mexico | Mexico City | 48 | 1082 |
1 | 3 | Woman | Energy | Tuesday, February 18, 2020 | Mexico | Mexico City | 48 | 1082 |
1 | 4 | Woman | Energy | Tuesday, February 18, 2020 | Mexico | Mexico City | 48 | 1082 |
1 | 5 | Man | Energy | Tuesday, February 18, 2020 | Mexico | Mexico City | 48 | 1082 |
1 | 6 | Man | Energy | Tuesday, February 18, 2020 | Mexico | Mexico City | 48 | 1082 |
2 | 7 | Man | Field and food | Thursday, March 5, 2020 | Mexico | Yucatan | 62 | 501 |
2 | 8 | Man | Field and food | Thursday, March 5, 2020 | Mexico | Mexico City | 62 | 501 |
2 | 9 | Woman | Field and food | Thursday, March 5, 2020 | Mexico | Mexico City | 62 | 501 |
2 | 10 | Woman | Field and food | Thursday, March 5, 2020 | Mexico | Mexico City | 62 | 501 |
2 | 11 | Woman | Field and food | Thursday, March 5, 2020 | Mexico | Mexico City | 62 | 501 |
3 | 12 | Man | Field and food | Tuesday, May 26, 2020 | Mexico | Mexico City | 46 | 417 |
3 | 13 | Man | Field and food | Tuesday, May 26, 2020 | Mexico | Mexico City | 46 | 417 |
3 | 14 | Woman | Field and food | Tuesday, May 26, 2020 | Mexico | Mexico City | 46 | 417 |
3 | 15 | Man | Field and food | Tuesday, May 26, 2020 | Mexico | Mexico City | 46 | 417 |
3 | 16 | Man | Field and food | Tuesday, May 26, 2020 | Mexico | Mexico City | 46 | 417 |
4 | 17 | Man | Energy | Thursday, June 4, 2020 | Mexico | Yucatan | 125 | 1325 |
4 | 18 | Man | Energy | Thursday, June 4, 2020 | Mexico | Mexico City | 125 | 1325 |
4 | 19 | Woman | Energy | Thursday, June 4, 2020 | Mexico | Mexico City | 125 | 1325 |
4 | 20 | Man | Energy | Thursday, June 4, 2020 | Mexico | Mexico City | 125 | 1325 |
4 | 21 | Woman | Energy | Thursday, June 4, 2020 | Mexico | Puebla | 125 | 1325 |
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:
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:
Example by filtering session 1:
I attach the PBIX file so you can see the development.
Proud to be a Super User!
Paul on Linkedin.
@Anonymous
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.
Proud to be a Super User!
Paul on Linkedin.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
59 |
User | Count |
---|---|
197 | |
116 | |
107 | |
77 | |
70 |