Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi All,
I want to count in sequence but using many dax or create new column i get duplicate sequence no. in duplicate data see Below:-
I want count see below:-
Regards,
NICK
Solved! Go to Solution.
First add an Index Column in your Table from the Query Editor >>"Add Column" tab
Then you can use this formula
Expected Situation 1 = RANKX ( FILTER ( Table1, Table1[Sub] = EARLIER ( Table1[Sub] ) ), Table1[Value] - Table1[Index] / 1000, , DESC, DENSE )
And this for expected situation 2
Expected Situation 2 = RANKX ( Table1, Table1[Value] - Table1[Index] / 1000,, DESC, DENSE )
Please see attached sample file as well
Hi All,
I think right now there is no solution of this situation.
That's why no body answering.
regards,
NICK
First add an Index Column in your Table from the Query Editor >>"Add Column" tab
Then you can use this formula
Expected Situation 1 = RANKX ( FILTER ( Table1, Table1[Sub] = EARLIER ( Table1[Sub] ) ), Table1[Value] - Table1[Index] / 1000, , DESC, DENSE )
And this for expected situation 2
Expected Situation 2 = RANKX ( Table1, Table1[Value] - Table1[Index] / 1000,, DESC, DENSE )
Please see attached sample file as well
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |