Forum Discussion
Naveennegi119
Helper III
Helper IIIIndex data highest to lowest
Hi all,
| Data | Expect result | ||||||
| Sub | Value | Index | Sub | Value | Index | ||
| ABC | 30 | ABC | 30 | 4 | |||
| ABC | 13 | ABC | 13 | 9 | |||
| ABC | 44 | ABC | 44 | 2 | |||
| ABC | 25 | ABC | 25 | 5 | |||
| ABC | 37 | ABC | 37 | 3 | |||
| ABC | 11 | ABC | 11 | 10 | |||
| ABC | 16 | ABC | 16 | 8 | |||
| ABC | 47 | ABC | 47 | 1 | |||
| ABC | 22 | ABC | 22 | 7 | |||
| ABC | 23 | ABC | 23 | 6 | |||
| DEF | 24 | DEF | 24 | 7 | |||
| DEF | 28 | DEF | 28 | 5 | |||
| DEF | 28 | DEF | 28 | 6 | |||
| DEF | 33 | DEF | 33 | 4 | |||
| DEF | 10 | DEF | 10 | 10 | |||
| DEF | 22 | DEF | 22 | 9 | |||
| DEF | 49 | DEF | 49 | 1 | |||
| DEF | 37 | DEF | 37 | 3 | |||
| DEF | 44 | DEF | 44 | 2 | |||
| DEF | 24 | DEF | 24 | 8 | |||
| GHI | 10 | GHI | 10 | 10 | |||
| GHI | 37 | GHI | 37 | 2 | |||
| GHI | 43 | GHI | 43 | 1 | |||
| GHI | 14 | GHI | 14 | 9 | |||
| GHI | 24 | GHI | 24 | 6 | |||
| GHI | 17 | GHI | 17 | 8 | |||
| GHI | 36 | GHI | 36 | 3 | |||
| GHI | 22 | GHI | 22 | 7 | |||
| GHI | 32 | GHI | 32 | 4 | |||
| GHI | 30 | GHI | 30 | 5 |
Advise me how to do this.
what I use measure or create new column.
regards,
NICK
You can add a new calculated column using the following formula.
New Column = RANKX( FILTER('Table1', 'Table1'[Sub]=EARLIER('Table1'[Sub]) ), 'Table1'[Value] )
3 Replies
- Phil_Seamark
Microsoft Employee
You can add a new calculated column using the following formula.
New Column = RANKX( FILTER('Table1', 'Table1'[Sub]=EARLIER('Table1'[Sub]) ), 'Table1'[Value] )
Naveennegi119Hi Phil_Seamark,
Thanks for fast reply.
it's working with small issue.
it's giving same no. for duplicate data.
Note:- Change few data to show you result.
any advise for that.
Regards,
NICK
Hi Naveennegi119,
Actually, current power bi will rank duplicate records as same ranking number.
AFAIK, power bi not contains row index and column index, so it is impossible to ranking duplicate records as different numbers.Regards,
Xiaoxin Sheng
