Forum Discussion
Ranking issue when filtering
Hi, I'm running into an issue when using the RANKX function within a table, and then filtering that table. Unfiltered, it works great, no issues with the actual ranked output field/column. But th...
Use Performance Analyzer to get the queries used both with and without filtering for an individual institution and compare them both in DAX Studio. It may be that some additional columns are being filtered beyond what you explicitly specify, e.g. a sort by column.
Once you know which columns are being filtered you may be able to alter your measures to factor that in.