RUNKX

[corrynduta]

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.

[Anonymous]

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.

[Anonymous]

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.

[corrynduta]

Hi

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