Forum Discussion

dmoney7612's avatar
dmoney7612
Helper II
5 years ago

Rank expression using a new measure

I am attempting to create a ranking expression for the YOY Sales columns in the matrix below. However, it appears I can only reference original columns from my table, and not the YOY formulas that were created afterwards as a new measure. Is there a way for the ranking expression to reference these newly created measures? Thanks in advance. 

 

 

 

 

Need Help

6 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi, dmoney7612 

    Please correct me if I wrongly understood your question.

    Can I know which column from which table did you use as a ROW in the matrix visualization?

     

    Hi, My name is Jihwan Kim.

    If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.

    • dmoney7612's avatar
      dmoney7612
      Helper II
      5 years ago

      I am having issues creating the expression, but I was hoping to rank the YOY Sales $ Growth and YOY Sales % Growth metrics I mentioned in my original message that I have in my"drive data set" table.

       

       

       

       

      • Jihwan_Kim's avatar
        Jihwan_Kim
        Super User
        5 years ago

        Hi,

        thank you for your feedback.

        Can you try to write the measure like below?

         

        Rankingmeasure = rankx (allselected('drive data set'), [YOY Sales $ Growth],,Desc)