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.
Go to 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.
For more details, please check the pbix as attached.
View solution in original post
Awesome. That worked!
Read the announcement for more information!
We're rolling out new Kudos Given badges. Find out how many Kudos you've given.
Get an overview of the events and great community content from November.
Find out where you can attend!