Rank by Department - Company Level

[davehus]

Hi,

I have the measure below that lets me rank products by each department type. However I hit a snag when I bring in branch level as it re-evalutes it.

What I want to do is to see what the department rank is for the company level against each branch. This will assist me in identifying top selling products out of stock in branches.

Rank by Revenue = RANKX(ALLEXCEPT('Product Table', 'Product Table'[Department Description]),
CALCULATE([Sales (Nett)]),,DESC,Dense)

Any ideas on how i might achieve this?

Thanks,

[v-shex-msft]

HI @davehus,

Since I'm not so clear for your data structure, can you please share some sample data for test?

Regards,

Xiaoxin Sheng