I can't clasify with RANKX in previous 12months

[Hvaldes]

Hello everyone.

I hope you can help me with this issue. Maybe it could be easy but I couln't find the correct way :(. I searched in many in many forums but I couldn't 😕

I have a table with differents data, for example, the customer name, the customer Code, the total sales ( 2018-2019 ), the sales potential and finally the previous sales 12 months. this last measure was calculate like this.

This is the final table that I got.

The problem that I have actually is when I wanted clasify in base of previous 12 months the rank function returns just the value 1.

Could you help me please??

If you need more details about that, please let me know.

Thanks a lot.

[v-lili6-msft]

HI, @Hvaldes 

You may try this formula:

RANK = RANKX(ALL('Table'[SDCUST]),[Prev12Months],,DESC)

If you still have problem, please share your simple sample pbix file, It may be a simple rank measure problem, but without sample data, it's hard to see what the problem is.

Regards,

Lin