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 useing formula for rank in column=

Rankall Rows Groupby Brand =
RANKX(FILTER(ALLSELECTED(Sheet1),Sheet1[brand_id]=EARLIER(Sheet1[brand_id])),Sheet1[Index],Sheet1[Index].can you please help me on this.. 

how to create the dynamic ranking in columns not in Measure.. 
Orginal

 

applying filter as gender and brand

 

with applying filter as brand

 

 

 

Need Help

3 Replies

  • 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