Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Filter Top N% Column Values by Other Column Values

I am migrating one report from Excel to Power BI. So, in Power BI I need to implement the same Excel Filter shown in attached screenshot. Basically the logic needs to be like, the Values in Column C ...
DAX Calculation
Filter
Top N
parry2k's avatar
parry2k
Icon for Super User rankSuper User
4 years ago

Anonymous file attached for your reference, enjoy!!

 

✨ 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.⚡

smpa01's avatar
smpa01
Icon for Community Champion rankCommunity Champion
4 years ago

Thanks parry2k AlexisOlson  for the quick response. parry2k  will study it and might get back to you with any follow uo question I might have.

 

Anonymous  guess you are sorted now.