Forum Discussion
RANKX with filter
ConnieMaldonado enjoyed doing this. check attached. I hope this is what you are looking for?
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS 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.⚡
ConnieMaldonado ok good, I already have sorted out the 2nd sheet, so just wanted to do the final output and that's where I found this discrepancy. Do you want this to work based on the date filter? So for example if one location has 12 id's and filter on certain period, brings it down to 8 ids', do you want that 75% of this filtered count or based on the original count (without filter)
Based on new count - i.e., dynamic based on slicer dates