Adding a rank label column to a matrix

AaronGlenn10 · ‎01-31-2022

All-Stars: I have a matrix with with the top 25 best performing locations [see below] - is there a way to insert a column that displays the actual ranking - e.g, "1, 2, 3, 4, 5, etc..." -easier to reference. Thank you!

v-shex-msft · ‎02-08-2022

Hi @AaronGlenn10,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

TheoC · ‎01-31-2022

Hi @AaronGlenn10

You can create a new calculated column like below:

Rank = RANKX ( 'Table' , 'Table'[Value] , , ASC )

Hope this helps.

Theo

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias