Rank with Filter,Slicer in Matrix

[Yonah]

Hi,
I'm not sure how to say it. But i'm working on a very complexd Matrix, how most show a lot of information. On of this information is the Ranking of the Percentage of Rev1 in the respective column.  Plus in the Matrix they are 4 Rows plus one Slicer, so in the best Case the Ranking is somewhat dynamic, depending on the selectet row.

So in the Ende the Matrix should lock like this:

Year	2019	2019	2019	2019	2019	2019	2020	2020	2020	2020	2020	2020
	Rev2	Quantity	Avg. Rev 2	Rank	Avg. Purchase	Avg. Rev1	Rev2	Quantity	Avg. Rev 2	Rank	Avg. Purchase	Avg. Rev1
ArticleCategory
Product Name
Colore
Country

Here you can find my data and Daschboard 
https://1drv.ms/u/s!AoFqgLqZH-C0hMly7YByjMZJbE-Fyg?e=flYXKl

Many thanks in advance

[amitchandak · Accepted solution]

@Yonah , Create 4 Rank and switch it using isinscope in reverse order child to parent

Rank ArticleCategory = rankx(allselected(Table[ArticleCategory]),[Measure])

Rank Product Name= rankx(allselected(Table[Product Name]),[Measure])

Rank Colore= rankx(allselected(Table[Colore]),[Measure])

Rank Country= rankx(allselected(Table[Country]),[Measure])

final Rank =  Switch(True() ,

isinscope(Table[Country]) , [Rank Country],

isinscope(Table[Colore]) , [Rank Colore],

isinscope(Table[Product Name]) , [Rank Product Name],

isinscope(Table[ArticleCategory ]) , [Rank ArticleCategory ] )

[Yonah]

Thank you