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 

 

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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Hi Mariusz ,

         

        Unfortynately rank equals "1" for all Accounts:(