Forum Discussion

Anonymous

Not applicable

7 years ago

Solved

RANK BY FIGURES AND GROUPS

Hello ,
I have different lot no column on that I want to grouping and based on tender rate decending order ranking .

If you can see in table blue color same tender rate have same rank (18).

If we cahnge lot no then rank should be dynamicaly change according to tender rate.

thanks in advance

reg ,
Pooja

hi, Anonymous

You could use RANKX Function to create a column by this formula as below:

Rank = RANKX(FILTER('Table','Table'[Lot No]=EARLIER('Table'[Lot No])),'Table'[Tender Rate],,DESC,Dense)

Note:

Skip	The next rank value, after a tie, is the rank value of the tie plus the count of tied values. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 16 (11 + 5). This is the default value when ties parameter is omitted.
Dense	The next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 12.

Result:

Best Regards,

Lin

Community Support

hi, Anonymous

You could use RANKX Function to create a column by this formula as below:

Rank = RANKX(FILTER('Table','Table'[Lot No]=EARLIER('Table'[Lot No])),'Table'[Tender Rate],,DESC,Dense)

Note:

Skip	The next rank value, after a tie, is the rank value of the tie plus the count of tied values. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 16 (11 + 5). This is the default value when ties parameter is omitted.
Dense	The next rank value, after a tie, is the next rank value. For example if five (5) values are tied with a rank of 11 then the next value will receive a rank of 12.

Result:

Best Regards,

Lin