Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Vendedor | Fecha | Ventas |
Vendedor1 | 1/1/2020 | 83763 |
Vendedor1 | 1/2/2020 | 38378 |
Vendedor1 | 1/3/2020 | 57456 |
Vendedor2 | 1/1/2020 | 523 |
Vendedor2 | 1/2/2020 | 8985 |
Vendedor2 | 1/3/2020 | 28663 |
Vendedor3 | 1/1/2020 | 12552 |
Vendedor3 | 1/2/2020 | 122185 |
Vendedor3 | 1/3/2020 | 75896 |
Vendedor4 | 1/1/2020 | 1125 |
Vendedor4 | 1/2/2020 | 12455 |
Vendedor4 | 1/3/2020 | 77754 |
Vendedor5 | 1/1/2020 | 78825 |
Vendedor5 | 1/2/2020 | 28552 |
Vendedor5 | 1/3/2020 | 185854 |
Vendedor6 | 1/1/2020 | 8545 |
Vendedor6 | 1/2/2020 | 105 |
Vendedor6 | 1/3/2020 | 9521 |
Vendedor7 | 1/1/2020 | 177514 |
Vendedor7 | 1/2/2020 | 11414 |
Vendedor7 | 1/3/2020 | 8558 |
Solved! Go to 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.
@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.