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
joshlwulf
Helper I
Helper I

Mostrar vendedores responsables de top n percent of total sales

Hola, estoy tratando de mostrar a los vendedores reponsibles para el top n por ciento de las ventas totales. He copiado los datos de muestra a continuación. Idealmente tendré una segmentación donde puedo arrastrar el control deslizante de 0 a 100 y ser capaz de mostrar a todos los vendedores que son responsables del 20% superior (por ejemplo) de ventas. Todas las soluciones que he encontrado usan rankx y me muestran el 20% superior de los vendedores (así que si tengo 100 vendedores me dará el 20% superior de los vendedores). Pero si los 2 mejores vendedores representan el 20% de las ventas, sólo quiero ver a esos vendedores. Gracias de antemano por su ayuda!

VendedorFechaVentas
Vendedor11/1/202083763
Vendedor11/2/202038378
Vendedor11/3/202057456
Vendedor21/1/2020523
Vendedor21/2/20208985
Vendedor21/3/202028663
Vendedor31/1/202012552
Vendedor31/2/2020122185
Vendedor31/3/202075896
Vendedor41/1/20201125
Vendedor41/2/202012455
Vendedor41/3/202077754
Vendedor51/1/202078825
Vendedor51/2/202028552
Vendedor51/3/2020185854
Vendedor61/1/20208545
Vendedor61/2/2020105
Vendedor61/3/20209521
Vendedor71/1/2020177514
Vendedor71/2/202011414
Vendedor71/3/20208558

1 ACCEPTED SOLUTION

@joshlwulf lo tengo, mira ahora

Apreciaría Kudos 🙂 si mi solución me ayudara.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

5 REPLIES 5
parry2k
Super User
Super User

@joshlwulf solución adjunta, hay muchas tablas en el modelo, sólo se centran en la tabla de vendedores.

Apreciaría Kudos 🙂 si mi solución me ayudara.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Gracias por su respuesta rápida! Desafortunadamente, lo que realmente estoy buscando es ver el top % y no los vendedores con más de un cierto % de ventas. Así que cuando la segmentación está en 80%, debería ver sólo los vendedores que están en la parte superior 80% de las ventas (Vendedores 1, 5, 3, 7)

@joshlwulf lo tengo, mira ahora

Apreciaría Kudos 🙂 si mi solución me ayudara.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Eso hace exactamente lo que necesito. Voy a realizar ingeniería inversa y ver cómo se hizo. ¡Muchas gracias!

@joshlwulf genial, siéntase libre de comunicarse si puedo responder a cualquier cosa. ¡¡Salud!!



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

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