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
1 ACCEPTED SOLUTION
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
Helpful resources
Microsoft Fabric Learn Together
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Power BI Monthly Update - April 2024
Check out the April 2024 Power BI update to learn about new features.
Fabric Community Update - April 2024
Find out what's new and trending in the Fabric Community.
