Forum Discussion
ConnieMaldonado
Responsive Resident
Responsive ResidentRANKX with filter
Hello: I have a table of jobs logged by technicians (techs) in the field. Each row represents a job logged by the technician and includes the number of hours logged for the job. The data is structur...
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.⚡
parry2k
Super User
Super UserConnieMaldonado just to make sure I understood it correctly. So you want to show 75% of technicians for each location, ranked based on their working hours between selected dates. Correct?
ConnieMaldonadoResponsive Resident
Responsive ResidentYes! You summarized it perfectly. Thanks.