Issue with RANKX

[mturcotte]

Hi,

I'm running into a problem with RANKX over a simple table with RANKX code that works with many other reports (over different tables)...

I'm sure the problem is a simple one to resolve but I just can't put my finger on it. I have used the problematic ranks to apply Conditional Highlighting on the TOP 1 rank to make my problem easy to spot across various columns.

What I want to acheive (and succeeded in doing so in other reports with other tables) is to have distinct ranks assigned to distinct values of the columns G, C, D, L (i.e. highest value of "G" gets rank 1 in column "G - Rank", second highest value of "G" gets rank 2 in column "G - Rank", etc). Currently, same rank gets applied to different values.

Any help is much appreciated!

ZIP file with the report:

https://1drv.ms/u/s!ArclD4PLnaKAnxOd1PoUWxk8igqe?e=IAxW5N

[jdbuchanan71]

@mturcotte 

If you change the ALLSELECTED ( RANKX_Problem ) to ALLSELECTED ( RANKX_Problem[YYYYMM] ) does that give you the result you are expecting?

[mturcotte]

Thank you jdbuchanan71 for your reply.

While your suggestion helps with the specific exemple report I posted, it made me realize that in the process of anonymizing the data from the original report where I'm struggling with RANKX I mangled some of the code I used for conditional highlighting background and font colors.

It also made me realize that in my anonymizing process I also took a shortcut that might play a role in my problem.

Currently, my problem with RANKX remains an issue in my actual report even when I make the adjustment corresponding to your suggestion.

So, I will need to investigate and possibly poste again with another revision to my example.

Thank again. MT

---

@jdbuchanan71 wrote:

@mturcotte 

If you change the ALLSELECTED ( RANKX_Problem ) to ALLSELECTED ( RANKX_Problem[YYYYMM] ) does that give you the result you are expecting?

---