Rankx Card Issue

DAX DAX Calculations
1

Having an issue with using a rankx calculation with a card visual. Using the following DAX for customer group ranking.

Customer group ranking= RANKX(ALL(Sales[Sold-to Party Group]),[CY Total Sales],DESC,Skip)

The above formula is simple and when the interactions with the date field are disabled the following is the table result which shows the customer group’s rank over time with an overall rank.

Results

Where I am having troubles is using this formula with a card. My intention is to show the overall rank in the card as a quick visual. But the grand total of the card is not matching the grand total in the table which has been verified as correct.

image

Any help solving this would be greatly appreciated.

2

Hello @MichaelRWechselberge and thank you for starting a conversation in the Community Forum. To allow members to assess the state, would you please add your work-in-progress Power BI Desktop File, the source data file in Excel format, any DAX measures formatted for the reader, and add a description and images of your desired result.

Please also ensure that the data model includes a dedicated Date table to accommodate any time intelligence efforts.

Are there any additional thoughts or questions which you would like to add that may be helpful to the reader who is not familiar with your line of business?