Rankx Function getting 1

[Anonymous]

Seeking help, for RANKX function I always getting 1 results.
I search a lot of function and I tried but it always return 1.

Thanks for your help

[MattAllington]

There seem to be a few issues.

1. Variables are immutable. Once they are set, they don't change. Move the variable code inside the rankx

2. The ALL inside the rankx would normally be placed around the table[column], and not the table

[Anonymous]

how about this ?  @MattAllington