Rankx - Card does not show the same information as the matrix ranking

[jjku]

Hi,

I have searched everywhere and I cannot seem to find a solution to my problem.

I have a simple table with this data (truncated)

I want use this DAX rankx formula to count the distinct site numbers by person.

Ranking =
RANKX (
    ALL ( EpayPunches[FNAME] ),
    CALCULATE ( DISTINCTCOUNT ( EpayPunches[SITENUMBER] ) ),
    ,
    ,
    DENSE
)

I have page level filters that filter out the day index (greater than -31) and by the task code as shown here

The matrix table is perfect as it shows this.

But, when I click on one person, I get a different ranking in the card vs the table.

I know it has something to do with the filters but I just can't figure out what it is.

[v-frfei-msft · Accepted solution]

Hi @jjku ,

To fix that, we can create a calculated table and make it related to the fact table as below.

Table = DISTINCT(EpayPunches[FNAME])

Then we  can fix the issue by updating the measure as below. Please note we should add the FANME column from the new calcualted table to the matrix.

Ranking = 
CALCULATE(
RANKX (
   ALL('Table'[FNAME]),
    CALCULATE(DISTINCTCOUNT(EpayPunches[SITENUMBER])),
    ,
    DESC
))

For more details, please check the pbix as attached.

[jjku]

Awesome. That worked!

Thanks!