Forum Discussion
Compare selected Client with TOP N Clients excluding the selected Client based on Volume
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.⚡
Super UserAnonymous , 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