Forum Discussion
Filter Top N% Column Values by Other Column Values
Anonymous attached
✨ Follow us on LinkedIn
Learn about conditional formatting at Microsoft Reactor
My latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) 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 not fully clear what you are looking for. can you provide an example of the output?
parry2k The calcuation measures that you provided are correct. My current requirement is as you can see in the attached picture i.e. whatsoever Suppliers get filtered as Top N%(Ex: Top 60%), I can get a sum of their count in a new column as shown in the attached picture and this Sum of their count must come from Number Supplier Orders column of Table1 as for each distinct Supplier in the Supplier Column there is a value "1" in Number Supplier Orders column of Table1(Please Refer Table1 data)