Forum Discussion
Rank System
- 1 year ago
I've tried many of the methods listed but none seem to work. I'm tabling this project right now and coming back to it when I have more of an idea of what exactly is causing the issue.
Hi bparker_ntst ,
Thanks for reaching out to Microsoft Fabric Community.
When using ranking logic in a dynamic dashboard with multiple filters and sliders, ensuring the rank calculation takes precedence can be tricky.
One function that could be useful in your scenario is ALLSELECTED. Unlike ALL, which removes all filters, ALLSELECTED respects selections made in slicers and recalculates rankings based on the filtered dataset. This ensures that ranking is applied only to visible records while maintaining the context of slicer selections.
Other functions like ALLEXCEPT, REMOVEFILTERS, and KEEPFILTERS also help control filter behavior. ALLEXCEPT removes filters from all columns except the specified ones, which can be useful for keeping certain filters intact while allowing rankings to adjust dynamically.
REMOVEFILTERS clears filters from selected columns or tables, helping reset the context when needed. KEEPFILTERS ensures previously applied filters remain effective when combined with other calculations, preserving intended logic in complex dashboards.
If you can share a sample dataset or more details about how your ranking measure is structured, we can provide better guidance.
Let us know how you're implementing the ranking and what behavior you're expecting so we can help troubleshoot further.
Hope this helps. Please reach out for further assistance.
Here are some related threads, you may find useful.
Solved: Re: Rankx Not working as expected when data is fil... - Microsoft Fabric Community
Re: Dynamic rankx() with filters - Microsoft Fabric Community
Solved: Dynamic Ranking - Measure - Microsoft Fabric Community
Please consider marking the helpful reply as Accepted Solution and giving kudos to assist others with similar issues.
Thank you.
Hi bparker_ntst ,
Just checking in to see if your query has been resolved and whether any of the responses provided were helpful.
If you're still facing issues or need further assistance, feel free to share more details or a sample dataset so we can help you better.
Thank you.