Compare selected Client with TOP N Clients excluding the selected Client based on Volume

[timmyeal]

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.

[parry2k]

@timmyeal 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. 

[parry2k · Accepted solution]

@timmyeal 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.⚡

[timmyeal]

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?

[timmyeal]

Thanks parry2k. I thought it is not possible but i thought wrong. This is awesome.

[amitchandak]

@timmyeal ,  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]))

Refer
https://community.powerbi.com/t5/Community-Blog/Dynamic-TopN-made-easy-with-What-If-Parameter/ba-p/3...

[timmyeal]

@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