Forum Discussion

Yonah's avatar
Yonah
Icon for Helper II rankHelper II
4 years ago
Solved

Rank with Filter,Slicer in Matrix

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 colum...
  • amitchandak's avatar
    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 ] )