Rank does not work

[Anonymous]

Hey Guys, 

I have created a Rank function with a Top/Bottom filter. It's working, but it is acting kinda weird. Please see the attached image does anybody know why is that or what's wrong? It's showing the same rank even though they are not the same numbers that we rank by. 

Equation - 

Rank = IF(
                    HASONEVALUE('Top/Bottom'[Order]),
                        SWITCH(
                            VALUES('Top/Bottom'[Order]),
                            "Top 10", RANKX(ALL(Store_dim[StoreName]),[GP per Customer],,DESC,Dense),
                           RANKX(ALL(Store_dim[StoreName]),[GP per Customer],,ASC,Dense)
                        ))

This is a very large file. I try to upload a sample file but it did not work. Sorry about that. 

One more thing, when I filter by Rank is less than 16, that is when my chart get weird 

Thank you so much 

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

Please modify the formula to below for a test.

Rank = IF(
                    HASONEVALUE('Top/Bottom'[Order]),
                        SWITCH(
                            VALUES('Top/Bottom'[Order]),
                            "Top 10", RANKX(ALLSELECTED(Store_dim),[GP per Customer],,DESC,Dense),
                           RANKX(ALLSELECTED(Store_dim),[GP per Customer],,ASC,Dense)
                        ))

Regards,
Yuliana Gu

[Anonymous]

@v-yulgu-msft

Thank you for the help. This is working. I appreciate your time.