RankX different answers when filtered

[Anonymous]

Hello,

I have what seems to be a common issue with RankX, but can't locate the exact solution. Here's my situation:

• I have a table including a ranking label that behaves as expected (rank number corresponds to score)
• I have a seperate one-row table that only shows the selected Brand from a synced slicer
• The one-row table has been created by copying-pasting the long table, therefore the same slicers apply to both (namely, country, month, quarter, brand (=label))
• The issue that I have is that, although all the metrics are identical between the two tables (score, MoM, YoY), the rank number is not always the same (which makes me think that it is a fluke when they are actually the same)
• Below a snapshot of the table and the relevant formulae that I'm using

Score = CALCULATE(AVERAGE('Brand Tracker'[score original]),FILTER('Brand Tracker', 'Brand Tracker'[Month]=[SelectedDate]))

Rank = RANKx(ALL(Brands[Label]),ABS([Score]))

Any suggestions on why the two tabs show a different rank # and how to resolve the issue are much appreciated!

Many thanks,

George

[v-chuncz-msft]

@Anonymous 

Notice the third parameter of RANKX and check the current context.

[Anonymous]

I have, but I have no idea what to do with it 🙂