My first post so apologies if this has been answered elsewhere.
I'm looking to add a ranking to a column and dynamically change the results and subsequently the rank when filtered by another field. The current syntax I'm using is:
RANKX ( ALL ( Table[Column_Name] ), CALCULATE ( SUM ( Table[Column_Name] ) ) )
This works perfectly fine in isolation and gives me the correct ranking. The issue is, when I create a filter using a field from another table, the field that I'm ranking remains the same, when I would expect it first to be filtered, and then the ranking to be applied.
As an example, let's say we have 100 companies and all are ranked 1-100, the current ranking syntax works fine. I then add a filter for company industry (which sits in another table), I would then expect when I select an industry for the initial results to change, say to 50 companies and then the ranking to display the 1-50 for the industry selected.
Hope that makes sense. Driving me mad so any help would be great, thank you.