Filtering on 2 tables without impacting Ranking

[Vladracs]

Hello Experts,

Not sure if this is possible, but I have a page with 2 tables where I applied some ranking , each table is the result for 1 year/month. 

It would be great if I could filter or show the ranking of a particular customer in an easy way.
Say for 2020:

Customer	Total Sales	Rank
A	40	1
B	30	2
C	20	3
D	10	4

Say for 2022:

Customer	Total Sales	Rank
C	40	1
A	30	2
D	20	3
B	10	4

I'd like an easy way to filter on say A and show that it is ranked 1st in 2020 but 2 and 2022.

the way the tables are build right now, if I click on A in one table, it could filter the second, but the ranking gets broken (it will always show 1, as its the only element on the other table).

Ranking is done with : mRanking = RANKX (ALLSELECTED(Ranking[DATA],Ranking[Customer]),[Total Sales],,DESC,Dense)

Thank you in advance.
Vlad

[Padycosmos · Accepted solution]

Hope this helps. There is a Year column in my table , which is used both in the slicer and table visual

[Vladracs]

ABS(BRILLIANT)