Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
@DomantasK You generally use RANKX for that sort of thing. To *Bleep* with RANKX! - Microsoft Power BI Community
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.
@DomantasK Or use this: The Mythical DAX Index - Microsoft Power BI Community
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
97 | |
75 | |
63 | |
62 |
User | Count |
---|---|
139 | |
104 | |
104 | |
80 | |
66 |