Forum Discussion
Dynamic indexing/ranking?
Hello,
I have a list with 1044 workers and need to calculate some number of workers over selected period-related KPI's to calculate.
At this stage, I need index column to adjust every time when I change some selections with the workers group. Because full list is from 1 to 1044 and that is okay, but when I deselect one of the groups, then there is 160 rows in table, however index numbers are the same and varies from 12 to 1038, while it should adjust to number of rows and be from 1 to 160. Any Ideas?
P.S. Workers are and should be ranked by date since they're working from.
3 Replies
DomantasK You generally use RANKX for that sort of thing. To *Bleep* with RANKX! - Microsoft Power BI Community
Greg_Deckler Rankx doesn't adjust to further filtering, shows same static values as the power-query made index column..
Also it shows same number if the "Works since" date is the same for multiple workers, so I guess this should be something like multiple criteria ranking, by "Works since date" (From oldest to newest) and if date is the same then rank by "Name" from A to Z.
