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.
@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.⚡
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.
Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@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.⚡
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.
@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]))
@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
User | Count |
---|---|
141 | |
60 | |
58 | |
58 | |
47 |
User | Count |
---|---|
135 | |
73 | |
58 | |
56 | |
51 |