Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Filter problem with rankx

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 ...
Jihwan_Kim's avatar
Jihwan_Kim
Super User
3 years ago

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's avatar
Syndicate_Admin
Administrator
3 years ago

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