DAX Dynamic RANKX not changing Axis values

[mpicca13]

I'm currently working on a Covid-19 Dashboard and I have created a measure which ranks the top 10 counties in the US by new confirmed cases for the day.

The measure for new confirmed cases is : 

DoD Confirmed Case Count Change = [Confirmed Cases for Current Day] - [Confirmed Cases Yesterday]

My Rank Measure is:

Top Counties =

VAR RankByCounty = RANKX( ALLSELECTED( Region[County & State]), [DoD Confirmed Case Count Change], , DESC)

RETURN

CALCULATE(

    [DoD Confirmed Case Count Change],

        FILTER( Region, RankByCounty <= 10 )

)  

Now when I select a date from the past, all of my [DoD Confirmed Case Count Change] values will change accordingly by the but the Axis values Region[County & State] will remain in place in the visual, this leads to the same county and region axis values but whichever county is not placed in top 10 for the selected prior date that is currently palced top 10 for the current date  will show a DoD case count value of 0.

See below images for reference:

Visual with date filter set to today:

Visual with date filter set to 4/03/2020:

 

I need te Axis values to change accordingly showing the corresponding DoD Case Count values

I feel that this issue lies in my Rank formula.

[mpicca13 · Accepted solution]

I have resolved the problem.

The issue was not in the DAX formula, it was in the visual interaction.

The interaction was set to "Highlight" .

I have changed it to "Filter" and now it works as intended.