DimDate filtering messes up ranking (RANKX) matrix visual

DAX DAX Calculations
1

Link To Files

Hi there,

I’m having issues with a RANKX situation and QuarterYear filter from my DimDate table. I’m tracking ranking not only for latest quarter, but previous quarter so my users can see how our partners are moving in the rankings.

The rankings work, but the list is a mess when you scroll to the bottom, or when you drill into certain rows.

First example of the messy data:

image
image1428×372 37.7 KB

Now same table, but clean:

image
image1169×230 24.3 KB

Notice how “FirstEnergy-Unidentified” is not displayed in the second pic. This is what I want.

Another example:

image
image1138×781 38.6 KB

All of those empty rows don’t even have data for this past quarter. Many of them haven’t had data since 2021!

How the bottom of the list should look:

image
image1215×760 77.2 KB

Notice how much cleaner that is.

If anyone can help me out I would be very grateful. This has been a thorn in my side for a little while now.
Sample.pbix (1.8 MB)

Sample Dataset.xlsx (161.3 KB)

Thanks!

2

Greetings, @attaboy000! Welcome to EnterpriseDNA, and thank you for contributing to the Community Forum with your questions. The Google Drive Link you provided is not set up for anonymous access and requires a login, which could pose challenges for other users. We recommend uploading any necessary sample files with the Community Forum the post itself, along with the source data file in Excel Format and any applicable code formatted. This is the minimum requirement for any new post. Thank you for your cooperation.

3

Hi @ystroman

Sorry about that! I was in a rush posting that I forgot to make the folder available to anyone. It should be accessible now.

I also added the files to my original post. Didn’t know I could just copy+paste the files right into it :slight_smile:

4

Bumping this for more visibility