Ranking by Region/Product Category/SKU

[Anonymous]

Hello reposting this as previous solution did not work 😞

I want to write a dax query, something using Rankx and windows function to get a table that will give me rank for each SKU'sales  based on the category and region filters.

I have 3 tables:

• Sales( has SKU,location and Sales)
• Location(has location with region)
• Product(which has Product and SKU)

linked to each(Sales table linked to Region by location code, Sales linked to Product by SKU and used to calculate the total sales.

I want to calculate the rank of each SKU by Product and Region and display then in ascending order.

Example:

Can anyone help me?

Thanks,

Ekta

@Zubair_Muhammad I saw that you solved a similar problem but it did not work for me. Could you tell me how to go about this one? Would be a great help!

[Anonymous]

Thanks a ton! Works perfectly 🙂

[Jihwan_Kim · Accepted solution]

Hi,

Please check the below picture and the attached pbix file.

Total sales: = 
SUM( Sales[Sales] )

Rank expected: = 
RANK (
    SKIP,
    SUMMARIZE (
        ALL ( Sales ),
        Location[Region],
        'Product'[Product],
        'Product'[SKU]
    ),
    ORDERBY ( [Total sales:], DESC ),
    DEFAULT,
    PARTITIONBY ( Location[Region] )
)