Forum Discussion
Solved
Dynamic Ranking based on slicer selection
Hi Everyone, I need help on dynamic ranking based on slicer selection
I have following database
| Company Name | Question NO | Countrty | Score |
| Acko | 1 | Argentina | 2 |
| Acko | 1 | Brazil | 3 |
| Acko | 1 | Peru | 3 |
| Acko | 1 | Spain | 4 |
| Acko | 1 | Spain | 4 |
| Acko | 1 | Brazil | 2 |
| Acko | 1 | Argentina | 3 |
| Acko | 1 | Argentina | 1 |
| Acko | 1 | Brazil | 2 |
| MAX | 1 | France | 3 |
| MAX | 1 | Italy | 1 |
| MAX | 1 | Mexico | 3 |
| MAX | 1 | Argentina | 5 |
| MAX | 1 | Mexico | 2 |
| MAX | 1 | Italy | 5 |
| MAX | 1 | Peru | 2 |
| MAX | 1 | Argentina | 1 |
I want if i choose any company name in slicer and want to show its score and rank
for ex if choose acko in slicer then table should like this
| Company Name: Acko | ||
| Country | Score | Rank |
| Argentina | 6 | 2 |
| Brazil | 7 | 3 |
| Peru | 3 | 1 |
| Spain | 8 | 4 |
and if i choose max, the table should like this
| Company Name: Max | ||
| Country | Score | Rank |
| Argentina | 6 | 1 |
| France | 3 | 3 |
| Italy | 6 | 1 |
| Mexico | 5 | 2 |
| Peru | 2 | 4 |
may anyone help me on this
- Rank Measure = RANKX(ALLSELECTED(RankTable[Countrty]),[Total Score],,DESC)
3 Replies
- Rank Measure = RANKX(ALLSELECTED(RankTable[Countrty]),[Total Score],,DESC)
Thanks Tahreem24
Hey kapildua16
Can you share the measure of which you are using to plot rank?
