Question about ranking Rankx in monthly result

[JuneZ123]

I want to show everyone's monthly ranking per Gross Margin $. However, some people ranking is incorrect. For example as below, this person Monthly ranking should be 4,6,4,6,3,1,1. In the chart, April and July ranking shows incorrectly. 

My Dax as below, please advice. 

Monthly Ranking =

IF(

ISFILTERED(Employee[Person Name by Last]),

RANKX(

CALCULATETABLE(

Employee,

all(Employee[Person Name by Last]),

Employee[Pres. Club Elig]=TRUE()

),

[YTD GM]

),

BLANK()

)

Thanks!

[v-mengzhu-msft]

Hi @JuneZ123 ,

If it is convenient, can you send me a sample data or a PBIX file without private data for my testing?

Best regards,

Community Support Team Selina zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[yaowen]

It is suggested to cut the table data to make it clearer. Try this code：

Monthly Ranking =
IF (
    ISFILTERED ( Employee[Person Name by Last] ),
    RANKX ( ALLEXCEPT ( Employee, Employee[Person Name by Last] ), [YTD GM] ),
    BLANK ()
)

[JuneZ123]

Thanks for the suggestion! I tried the DAX, it is not working properly. It shows as following.