Forum Discussion
Responsive ResidentRANKX 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.⚡
Super UserConnieMaldonado Hey, sorry. Missed that. Can you share a sample pbix file? You can share using One drive/google drive.
Responsive ResidentHere you go Parry2k:
https://drive.google.com/drive/folders/1n0OyvFrSmnEhpKdMKYSEHhT7qukVf_Ct?usp=sharing
I tried various combinations of using calculatetable, but couldn't get the result. In the Google folder, I included a pbix file and a spreadsheet to make it clear. I only want to include on my report techs who are in the top 75% of the count by location, based on hours during the timeframe entered in the slicer. Whew! It's alot, and possibly the most complicated thing I've done, so I really appreciate your help. Let me know if you have an issue with the link.