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 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:

Year201920192019201920192019202020202020202020202020
 Rev2QuantityAvg. Rev 2Rank Avg. PurchaseAvg. Rev1Rev2QuantityAvg. Rev 2Rank Avg. PurchaseAvg. 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

 

Need Help
  • amitchandak's avatar
    amitchandak
    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 ] )

2 Replies

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    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 ] )