Forum Discussion
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- ...
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.
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.
Hi
Below is the shot with Filters on. Thank you for noticing that Esaro is still being ranked. Had not noticed.