Filter problem with rankx

[Syndicate_Admin]

Hello. I'm trying to rank the behavior of a number of products over time. It turns out that there are times that the RankX solves the ranking correctly but there are times that it repeats the values and I do not know why it does.

Has anyone faced this problem and could you help me?

This is the DAX of rankx

Ranking2 = RANKX(ALL('Data (2)'[REG. CORPORATION]),CALCULATE(sum('Data (2)'[MXN])),,DESC,Skip)

and this is the picture of the problem

Thanks a lot

[Jihwan_Kim]

Hi,

I am not sure how your Data model looks like, but please try the below whether it suits your requirement.

Ranking2 =
RANKX (
    FILTER (
        SUMMARIZE (
            ALL ( 'Data (2)' ),
            'Data (2)'[REG. CORPORATION],
            'CalendarTable'[Month]
        ),
        'CalendarTable'[Month] = MAX ( 'CalendarTable'[Month] )
    ),
    CALCULATE ( SUM ( 'Data (2)'[MXN] ) ),
    ,
    DESC,
    SKIP
)

[Syndicate_Admin]

Thank you very much, if it works, only there is something strange that is happening with the RankX function, when I apply it to all the data it works well but when I apply a company filter the function no longer works well until I select several companies.

In the image we can see that Company 170 in the month of July has the10th position when all the companies are selected.

But when you select that company only, the ranking changes to 1 and is corrected back to 10 when more than one company is selected.

Hopefully you can help me find what I am doing wrong with the filters, I have been trying for hours and I can not find the problem

Thanks a lot

[Jihwan_Kim]

Hi,

Thank you for your feedback.

I am not sure how your data model looks like, but I think you can try to replace ALL in the measure with ALLSELECTED whether it suits your requirement.

[Syndicate_Admin]

Hello. The Allselect does not help solve the problem.

Add the link with my data model in case you can help me check that I'm doing wrong.

Thanks a lot

https://drive.google.com/drive/folders/1Ii5y_4LY-rihNpbCqMnkN7WXOF__Kmm2?usp=sharing