Rank System

Hi bparker_ntst 
The issue you're facing with your dynamic ranking dashboard stems from how Power BI handles filter context, especially when your report includes multiple slicers, filters, and other ranking systems. While your approach of using an unconnected rank table and DAX measures to calculate rank and corresponding values works well in a simple setup, it can break down in complex dashboards due to filter interference. By default, slicers and filters on the report page influence the data being evaluated by your measures, which can cause your ranks to behave unpredictably or return incorrect results. To make your ranking system take precedence and function reliably regardless of other filters, you need to explicitly control the evaluation context in your DAX measures. This is typically done by using functions like `ALL()` or `REMOVEFILTERS()` to remove specific filters that could interfere with ranking, ensuring that ranks are calculated across the full dataset or a consistent subset. Additionally, using `FILTER()` inside your value measure with a comparison to the selected rank ensures that only data matching the selected rank is returned. It's also important to keep your rank table disconnected and avoid any unintended relationships. In short, by isolating the ranking logic from the report’s broader filter context using proper DAX techniques, you can ensure your dynamic ranking system remains stable and effective even in complex dashboards.