cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
mpicca13
Frequent Visitor

DAX Dynamic RANKX not changing Axis values

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:
Capture.PNG
 
Visual with date filter set to 4/03/2020:
Capture1.PNG 
 
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.
 
1 ACCEPTED SOLUTION

Accepted Solutions
mpicca13
Frequent Visitor

Re: DAX Dynamic RANKX not changing Axis values

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.

View solution in original post

1 REPLY 1
mpicca13
Frequent Visitor

Re: DAX Dynamic RANKX not changing Axis values

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.

View solution in original post

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors