topic Re: RUNKX in DAX Commands and Tips

RUNKX

Anonymous — Fri, 23 Aug 2019 08:33:39 GMT

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.

Re: RUNKX

Anonymous — Fri, 23 Aug 2019 12:09:23 GMT

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.

Re: RUNKX

Anonymous — Fri, 23 Aug 2019 12:11:33 GMT

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.

Re: RUNKX

Anonymous — Mon, 26 Aug 2019 07:10:06 GMT

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