Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

RANKX additional context

Hi Friends,   I have issue with RANKX    When I have table only with Customer Name and RANKX formula everything works well.     But when i'm adding addinional context (Company Type...
Need Help
  • Mariusz's avatar
    Mariusz
    6 years ago

    Hi  Anonymous

     

    I made some changes to your model.


    1. Changed the relationship direction and type 

    2. Rank Measure - it needs to be ALL( Account[Account] ) not ALL(  Revenue [Account] )

    3. In your visuals use the fields from the Account table, not from Revenue 

     

    Please see the attached file.

     

    Best Regards,
    Mariusz

    If this post helps, then please consider Accepting it as the solution.

     

Mariusz's avatar
Mariusz
Community Champion
6 years ago

Hi Anonymous 

 

Sorry I missed that, please see the attached with a fix to the Rank Measure.

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Mariusz It works!

Thank you - you're a magician)

Have a nice day!

Regards,

Oleh