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 sorry for the delay on this, I think I'm almost done but need to understand bit:
on the final output page, the first row, how come you have total of hours 91 for this loc1, id and date
where if you look at raw data (first page in excel ) the total hours are 139.06 (Highlighted in yellow) for the same date:
Am I missing something or it is something else?
Let me check it! Hold on.
You are correct - I probably made a change and didn't update stuff when trying to "dummy" the data. My apologies. The desired output has records by ID, date - it represents the source data I have. Since this tech is in the top 75% by tech count, all of his records will be included in the report. I hope that makes sense. 🙂 Thank you so much! I haven't been able to figure out the date thing - how to get the logic to work when you change the slicer dates. It's a crazy way to weed out low-performers, but I have other reports I'll likely use the logic for.
