Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Dynamic ranking

    Hi All,   Please help me on dynamic Ranking in Column Not in Measure.....   i have created the rank column by brand wise and i applied any filters the rank is not comeing correctly . i am u...
Need Help
v-juanli-msft's avatar
v-juanli-msft
Community Support
7 years ago

Hi Anonymous 

Create measures

Measure = SUM(Sheet6[Index])

Measure 2 = 
RANKX(FILTER(ALLSELECTED(Sheet6),[Brand]=MAX(Sheet6[Brand])),[Measure],,DESC)

 

Best Regards

Maggie

 

Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

     

     

    Hi,, thank you for your quick reply

     

    but i need to create the same thing in calculated columns not in measures. if its possible to create the same thing in calculated columns????

     

    Because i need to use the calculated column in matrix visual columns... Measures we can not used in the columns..

     please help me on this issuse......

    • v-juanli-msft's avatar
      v-juanli-msft
      Community Support
      7 years ago

      Hi Anonymous 

      It is impossible for a calcuated column to change dynamic based on selection.

       

      Best Regards

      Maggie