Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I created a rank with this code
RANK = RANKX(FILTER(
'Table',
'Table'[ID]= EARLIER('Table'[ID]) &&
'Table'[Date Time] < EARLIER('Table'[Date Time])
),'Table'[Date Time],,ASC,Skip)which to some extent worked and followed the proper order but it gave me 1,1,1,4 instead of 1,2,3,4. The Date and Time is the same for the first three rows. Next thing I did was add a column with random values.
SupportingColumn = RANDBETWEEN(1,COUNTROWS('Table'))
I was hoping that I could still do the same grouping but sort it by some index cause it doesn't matter which row is before the other. However it completely disorigented my position.
RANK = RANKX(FILTER(
'Table',
'Table'[ID]= EARLIER('Table'[ID]) &&
'Table'[Date Time] < EARLIER('Table'[Date Time])
),'Table'[SupportingColumn],,ASC,Skip)
same code as before but now completely placing the values all over the place. Not sure how to do this.
@user35131 change
Skip to DENSE
So change from skip to dense doesn't solve it. What it does it changes 1,1,1,4 to 111,2. I'm more satisfied with the 1,1,1,4 because at least the 4 is in the proper position.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 61 | |
| 46 | |
| 40 | |
| 38 | |
| 22 |
| User | Count |
|---|---|
| 178 | |
| 133 | |
| 118 | |
| 82 | |
| 56 |