March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
I am new to Power BI. I have a requirement to compare selected client with TOP N clients based on volume excluding the selected client. The Client Slicer (dropdown slicer) is where the client is selected to compare with the Top N clients. For example, the image below:
If I selected Client E on my Client Slicer and comparing E with Top 3, then I want to achieve report below:
However, if I selected Client E to compare with Top 4, my result should look like
Note that since i selected E, it will be excluded from the Top N returns.
I will appreciate any help.
Solved! Go to Solution.
@Anonymous Thanks for you reaching out, solution is attached, you can tweak it as per your need.
Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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.
@Anonymous Glad, it worked out, I'm going to write a blog post on this and share it with the community. I like these kinds of scenarios and love sharing with others so that they can learn from it.
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.
@Anonymous Thanks for you reaching out, solution is attached, you can tweak it as per your need.
Check my latest blog post Improve UX: Show Year in Legend When Using Time Intelligence Measures | PeryTUS IT Solutions I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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 solution. However, I want to ask that when the visual is Matrix the Selected Client won't appear at the top. How can I go about the selected client appearing at the top when using Matrix visual?
Thanks parry2k. I thought it is not possible but i thought wrong. This is awesome.
@Anonymous , Prefer to create a client table disconnected
A new measure for volume
Vol= calculate(sum(Table[volumne]), filter(Table, not Table[Client] in values(client[client])))
Try TOP N like, Use a what-if to change 10
Top N Rank = CALCULATE([Vol],TOPN(10,allselected(Table[Client]),[Vol],DESC),VALUES(Table[Client]))
Top N Rank = CALCULATE([Vol],TOPN(10,filter(allselected(Table[Client]), not Table[Client] in values(client[client])),[Vol],DESC),VALUES(Table[Client]))
@amitchandak Thanks for you reply. However, I have tried to use your Dax but it is not working. Please can you elaborate more with pbix if possible. Thanks
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
90 | |
89 | |
85 | |
73 | |
49 |
User | Count |
---|---|
169 | |
144 | |
90 | |
70 | |
58 |