RANKX additional context

[Anonymous]

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

[amitchandak]

Refer

https://radacad.com/how-to-use-rankx-in-dax-part-2-of-3-calculated-measures

[Mariusz]

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]

@Mariusz,

You can find Data Sample and expected outcome via this  Link  

Thanks for your help!

Regards,

Oleh

[Mariusz · Accepted solution]

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]

Hi @Mariusz ,

Unfortynately rank equals "1" for all Accounts:(

[Mariusz]

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]

@Mariusz It works!

Thank you - you're a magician)

Have a nice day!

Regards,

Oleh

[Anonymous]