RUNKX

[Anonymous]

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.

[v-piga-msft]

Hi @Anonymous ,

If it is convenient, could you show the output which the CO rank shows blank value? Do you create the country slicer in another page?

In addition, I would appreciate it if you could show the data sample and your desired output so that we could have a test on it.

Best Regards,

Cherry

[Anonymous]

Hi,

Thank you for responding.

My desired output is to get the CO rank value e.g 9 for Ethiopia. Instead, I am Getting a (Blank)-As seen below.

My data is too big- with may tables- It may be too much to share.