Forum Discussion
Rank with Filter,Slicer in Matrix
- 4 years ago
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 , 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 ] )
- Yonah4 years ago
Helper II
Thank you