Forum Discussion
Solved
Increment in Calculated Column
Hi
Below is my data and last column is the required result. Can anyone please help.
Hi tameemyousaf ,
You can create the following column
Required result = IF([Count]=0,0, RANKX(FILTER('Table',[Count]=0),[Number],,ASC,Dense))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
7 Replies
Jihwan_Kim Thanks for your response. Actually number is the serial number and what if the number is same?
I do not understand why you put my measure into the different data and expect to see the same result.
Hi tameemyousaf ,
You can create the following column
Required result = IF([Count]=0,0, RANKX(FILTER('Table',[Count]=0),[Number],,ASC,Dense))Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
