topic Re: Ranking by Region/Product Category/SKU in DAX Commands and Tips

Ranking by Region/Product Category/SKU

Anonymous — Fri, 13 Oct 2023 16:41:52 GMT

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!

Re: Ranking by Region/Product Category/SKU

Jihwan_Kim — Sat, 14 Oct 2023 10:02:36 GMT

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] ) )

Re: Ranking by Region/Product Category/SKU

Anonymous — Mon, 16 Oct 2023 14:58:59 GMT

Thanks a ton! Works perfectly 🙂