Forum Discussion

davehus's avatar
davehus
Icon for Memorable Member rankMemorable Member
7 years ago

Rank by Department - Company Level

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,
 
Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI davehus,

     

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

     

    Regards,

    Xiaoxin Sheng