Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

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. 







Community Champion
Community Champion

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.

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.







thank you for your feedback.

Can you try to write the measure like below?


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





Each ranking is "1" when using this measure.





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.

It doesn't allow me to share .pbix file

Helpful resources

PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!


Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors