Index data highest to lowest

[Naveennegi119]

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

[Phil_Seamark · Accepted solution]

Hi @Naveennegi119

You can add a new calculated column using the following formula.

New Column = 
    RANKX(
        FILTER('Table1',
            'Table1'[Sub]=EARLIER('Table1'[Sub])
            ),
            'Table1'[Value]
            )

[Naveennegi119]

Hi @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

[Anonymous]

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