Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi, I'm trying to display the sellers reponsible for the top n percent of total sales. I've copied sample data below. Ideally I'll have a slicer where I can drag the slider from 0 to 100 and be able to show all of the sellers that are responsible for the top 20% (for example) of sales. All of the solutions I've found use rankx and show me the top 20% of sellers (so if I have 100 sellers it will give me the top 20% of sellers). But if the top 2 sellers account for 20% of the sales, I only want to see those sellers. Thanks in advance for your help!
Seller | Date | Sales |
Seller1 | 1/1/2020 | 83763 |
Seller1 | 1/2/2020 | 38378 |
Seller1 | 1/3/2020 | 57456 |
Seller2 | 1/1/2020 | 523 |
Seller2 | 1/2/2020 | 8985 |
Seller2 | 1/3/2020 | 28663 |
Seller3 | 1/1/2020 | 12552 |
Seller3 | 1/2/2020 | 122185 |
Seller3 | 1/3/2020 | 75896 |
Seller4 | 1/1/2020 | 1125 |
Seller4 | 1/2/2020 | 12455 |
Seller4 | 1/3/2020 | 77754 |
Seller5 | 1/1/2020 | 78825 |
Seller5 | 1/2/2020 | 28552 |
Seller5 | 1/3/2020 | 185854 |
Seller6 | 1/1/2020 | 8545 |
Seller6 | 1/2/2020 | 105 |
Seller6 | 1/3/2020 | 9521 |
Seller7 | 1/1/2020 | 177514 |
Seller7 | 1/2/2020 | 11414 |
Seller7 | 1/3/2020 | 8558 |
Solved! Go to Solution.
@joshlwulf got it, check now
Would appreciate Kudos 🙂 if my solution helped.
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 solution attached, there are many tables in the model, just focus on sellers table.
Would appreciate Kudos 🙂 if my solution helped.
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.
Thanks for your quick response! Unfortunately, what I'm actually looking for is to see the top % and not the sellers with over a certain % of sales. So when the slicer is on 80%, I should see only the sellers who are in the top 80% of sales (Sellers 1, 5, 3, 7)
@joshlwulf got it, check now
Would appreciate Kudos 🙂 if my solution helped.
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.
That does exactly what I need it to. I'll reverse engineer it and see how it was done. Thanks so much!
@joshlwulf great, feel free to reach out if I can answer anything. Cheers!!
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |