Forum Discussion
Filtering on 2 tables without impacting Ranking
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
Hope this helps. There is a Year column in my table , which is used both in the slicer and table visual
2 Replies
Hope this helps. There is a Year column in my table , which is used both in the slicer and table visual
ABS(BRILLIANT)
