Rank - Power BI

Question

Hi, I want to find the rank of sales and the products category wise. Can anyone help?

Answer 1

Hi Anitha,

Drop Category, product-id, and sales into the sheet.

Use Rank to get the rank based on sales for each product category wise.

Now add a measure with below code -

Rank prod = RANKX(ALL(Orders[Product ID]),[total sales],,DESC)

Hope it helps.