Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

RUNKX

CO Rank =
IF(
ISINSCOPE(KPIs[Country]),
IF(
SELECTEDVALUE ( KPIs[Country] ) <> "Esaro",
RANKX(
ALL(KPIs[Country]),[Avg Rank])," "))
 
It works fine when I display the information as a table- see below:
 
However, When I want to display the CO rank in a different page with a country FILTER. it shows (blank) , How do i fix this? Any help will be appreciated.
rank.PNG

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Would you mind sharing a screenshot of what's wrong when you have a filter on country?

    Do you also realize that even though you exclude Esaro, it's still being taken into account when calculating CO Rank of the other countries?

    Best
    D.
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi

       

      Below is the shot with Filters on. Thank you for noticing that Esaro is still being ranked. Had not noticed.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago
    Best of all, you could share the file with the data, if that's not a big problem. Alternatively, you could anonymize the data and still share the file.

    Best
    D.