How to use Rankx for top 5 column (country) on monthly basis

[SajnaM]

I'm creating a Power Bi report.

I have a table which give list of applicable countries on monthly basis. I like to get top 5 countries of each month to show the monthly trend of top 5 items.

Below is the data sample - I need a rank number on countries - which is top 5 countries of feb and top 5 for mar. Can you please help me to make this?

Going forward, we will get monthly data similar to this. so, every month, we should get this. Not sure how to group date and country and get the rank for each month.

[v-lionel-msft]

Hi @SajnaM ,

Has your problem been solved?

Best regards,
Lionel Chen

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

[v-lionel-msft]

Hi @SajnaM ,

Try to create such a measure.

Rank = 
RANKX(
    FILTER(
        ALL(Sheet4),
        [Date].[Year] = MAX([Date].[Year]) && [Date].[MonthNo] = MAX([Date].[MonthNo]) 
    ),
    CALCULATE(SUM(Sheet4[Values])), , DESC, Dense
)

Best regards,
Lionel Chen

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