Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dmoney7612
Helper II
Helper II

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. 

 

dmoney7612_0-1617645330884.png

 

dmoney7612_1-1617645515159.png

 

 

6 REPLIES 6
Jihwan_Kim
Super User
Super User

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.

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


Go to My LinkedIn Page


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.

 

dmoney7612_0-1617646751691.png

 

 

 

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)

 

 

 

 

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


Go to My LinkedIn Page


Each ranking is "1" when using this measure.

 

dmoney7612_0-1617648040597.png

 

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.

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


Go to My LinkedIn Page


It doesn't allow me to share .pbix file

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.