Forum Discussion

dmoney7612's avatar
dmoney7612
Icon for Helper II rankHelper 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 we...
Need Help
Jihwan_Kim's avatar
Jihwan_Kim
Icon for Super User rankSuper 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)

 

 

 

 

dmoney7612's avatar
dmoney7612
Icon for Helper II rankHelper II
5 years ago

Each ranking is "1" when using this measure.

 

 

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Icon for Super User rankSuper User
    5 years ago

    Hi

    Thank you for your feedback.

    If it is OK with you, please share your sample pbix file, then I can come up with a more accurate measure.

     

    thank you.

    • dmoney7612's avatar
      dmoney7612
      Icon for Helper II rankHelper II
      5 years ago

      It doesn't allow me to share .pbix file