Forum Discussion

joshua1990's avatar
joshua1990
Post Prodigy
4 years ago
Solved

Excluding dimenions within RANKX

Hi experts! Let's say I have table that contains a unique list of products as a dimensional table. TableAtr Product A1 A2 B1   Then I have a second table that contains transaction...
Need Help
  • ValtteriN's avatar
    ValtteriN
    4 years ago

    Hi,

    Here is one way to do this:

    ranking with dep = RANKX(ALL('Rank with dep'),
    calculate(SUM('Rank with dep'[Value]),ALL('Rank with dep'[Department])),,DESC)

    I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

ValtteriN's avatar
ValtteriN
Community Champion
4 years ago

Hi,

Here is one way to do this:

ranking with dep = RANKX(ALL('Rank with dep'),
calculate(SUM('Rank with dep'[Value]),ALL('Rank with dep'[Department])),,DESC)

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!