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.⚡
Community ChampionAnonymous
Basically the logic needs to be like, the Values in Column C are to be summarized by Values in Column A and then the Values in Column B need to be filtered(Only Top 60% Values) by summarized Values of Column C
- Just so I understand, Order Value USD BR needs to be summarized by Local Product Group Unit
which is the following
and then the Values in Column B need to be filtered(Only Top 60% Values) by summarized Values of Column C - so does it mean that DAX needs to return the top 60% (Order Value USD BR/sum of Order Value USD BR by Local Product Group Unit)
If I follow the above, for the given dataset, DAX only needs to return this row only as everything else is <=60%
Please confirm
Once SUM of Order Value USD BR is done by Distinct Local Product Group Unit, We need to Filter Out All those "Suppliers" from Supplier column which covered Top 60% portion of SUM of Order Value USD BR by Distinct Local Product Group Unit
- smpa01
Anonymous so what is the desired output for the given dataset?
A table as that shown in the attached screenshot should be implemented as Power BI table(or Matrix) visual. Basically, implementing the filter as shown in the attached screenshot and applying it to table(or Matrix) visual.