Ranking by Multiple Columns (Guest Post by BI Elite)

/ bi-elite
Today's video is a guest post from Parker over at BI Elite. Parker has generously agreed to do a guest video for my channel, where he'll explain how to use DAX to create a ranking based on multiple columns. So give it a watch and see how quickly and easily it can be done.
VIDEO CHAPTERS 🎥
0:00 - Start of Video
0:12 - Start of Demo
0:38 - Showing the Model
1:40 - Creating 1st DAX Measure
3:26 - Creating 2nd DAX Measure
LET'S CONNECT! 🧑🏽‍🤝‍🧑🏽 🌟
-- / havensbi
-- / reidhavens
-- / havensconsulting
HAVENS CONSULTING PAGES 📄
Home Page - www.havensconsulting.net
Blog - www.havensconsulting.net/blog-...
Blog Files - www.havensconsulting.net/blog-...
Files & Templates - www.havensconsulting.net/files...
Consulting Services - www.havensconsulting.net/consu...
Contact & Support - www.havensconsulting.net/conta...
EMAIL US AT 📧
[e-mail]
#PowerBI #PBI #microsoftpowerbi #HavensConsulting #powerplatform #microsoft #businessintelligence #datascience #office #data #digitaltransformation #dataanalytics #tableau #excel #powerapps #datavisualization #dashboard #sharepoint #python #bi #analytics #cloud #azure #bigdata #sqlserver #software #sql #dynamics #dataanalysis #yammer #microsoftpowerbi #onedrive #machinelearning #bhfyp #powerbidesktop

[@yout1877]

This has been a lifesaver. Had searched dozens of blogs and videos, and this finally gave me the answer.

[@angeloponciano5724]

congrats, this is amazing

[@HavensConsulting]

Thank you so much!

[@cleanermail8816]

Nice to see collaboration in the community! Great, easy to understand video!

[@DF-yj4qs]

I have been looking for a tutorial on this EXACT situation for at least two weeks! You are the man!
Thank you much

[@HavensConsulting]

Glad it helped! :)

[@heliod4459]

Fantastic!

[@fuubutsushio8530]

Question: What if we add another column of 'months' and want to find the highest rank for each social netwrk and the month in which they had highest rank?

[@nicholaskeogh1121]

I know its two years later but you can just keep stacking variables for each column you want, then add these in the FILTER with &&

[@muhammadtanveerislam5998]

wonderful bro

[@kevinlabore1726]

Cool! Question -- does this only work when using "MAX" or can you use other variations?

[@RobIvy]

This would be exactly what I need....except that I get a circular dependency error in my model. Any ideas why that might happen?

[@suniltak5707]

Can we have same values for 2 records? So lets say for Facebook, we have 2 records with same value like 100 . Then will be populated by the RANKX function. I need increment number for each record irrespective of duplicate record. How can achieve that?

[@rajeshkhanna8709]

Hi, I tried the same way on my computer but technically i am faceing some error

[@KK-kc1mf]

Hi, is there a possibility to do it for column in a table inside model, not in visualisation?

[@HavensConsulting]

That same logic should be transferable into a DAX calculated column if you wanted :)

[@jithiljohn2961]

I have customer name, customer state and sale amount. But I want to rank based on customer name. Please help

[@HavensConsulting]

Hi Jithil, that question might be better suited to post on the Power BI community site (community.powerbi.com/) where you can include a file and DAX measure. If you post it there and email me the link to your problem, I'll try to look at it when I have time

[@akshayachandrasekar8285]

Hey try this,
New measure = rankx(All(table name[customer name]), total sales)