cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
joshlwulf
Helper I
Helper I

Show sellers responsible for top n percent of total sales

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! 

 

 

SellerDateSales
Seller11/1/202083763
Seller11/2/202038378
Seller11/3/202057456
Seller21/1/2020523
Seller21/2/20208985
Seller21/3/202028663
Seller31/1/202012552
Seller31/2/2020122185
Seller31/3/202075896
Seller41/1/20201125
Seller41/2/202012455
Seller41/3/202077754
Seller51/1/202078825
Seller51/2/202028552
Seller51/3/2020185854
Seller61/1/20208545
Seller61/2/2020105
Seller61/3/20209521
Seller71/1/2020177514
Seller71/2/202011414
Seller71/3/20208558

 

 

1 ACCEPTED SOLUTION

@joshlwulf got it, check now

 

Would appreciate Kudos 🙂 if my solution helped.






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  solution attached, there are many tables in the model, just focus on sellers table.

 

Would appreciate Kudos 🙂 if my solution helped.






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.






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

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!!






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
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.