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, Domain ) RANKX does not work properly.

 

Could you please help?

 

Thanks in advance!

 

Regards,

Oleh

 

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.

     

8 Replies

  • Mariusz's avatar
    Mariusz
    Community Champion
    6 years ago

    Hi Anonymous 

     

    If you are trying to rank over the columns you are adding then you will need to include these columns in the first argument of rankx  ALL( column1, column2, column3 ).

     

    If you are looking for a different outcome then please can you provide a data sample and an outcome expected.

     

     

    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,

       

      You can find Data Sample and expected outcome via this  Link  

       

       

      Thanks for your help!

      Regards,

      Oleh

      • Mariusz's avatar
        Mariusz
        Community Champion
        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.