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.
 

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    7 years ago

    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's avatar
      Anonymous
      Not applicable
      7 years ago

      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.