Dynamic Ranking based on slicer selection

[kapildua16]

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

[Tahreem24 · Accepted solution]

@kapildua16 ,

Rank Measure = RANKX(ALLSELECTED(RankTable[Countrty]),[Total Score],,DESC)

[kapildua16]

Thanks @Tahreem24 

[Dhairya]

Hey @kapildua16 
Can you share the measure of which you are using to plot rank?