Advanced RANKX - How To Understand This Function More Deeply

[@EnterpriseDNA]

***** Learning Power BI? ***** FREE COURSE - Ultimate Beginners Guide To Power BI - portal.enterprisedna.co/p/ultimate-beginners-guide-to-power-bi FREE COURSE - Ultimate Beginners Guide To DAX - portal.enterprisedna.co/p/ultimate-beginners-guide-to-dax FREE - Power BI Resources - enterprisedna.co/power-bi-resources FREE - 60 Page DAX Reference Guide Download - enterprisedna.co/dax-formula-reference-guide-download/ Enterprise DNA Membership - enterprisedna.co/membership Enterprise DNA Online - portal.enterprisedna.co/ Enterprise DNA Events - enterprisedna.co/enterprise-dna-events-page/ ***** Related Links ***** Creating Dynamic Ranking Tables Using RANKX In Power BI - blog.enterprisedna.co/dynamic-ranking-tables-in-power-bi/ RANKX Considerations - Power BI And DAX Formula Concepts - blog.enterprisedna.co/deep-dive-into-rankx-dax-formula-concepts-in-power-bi/ Find Top Customers Using RANKX In Power BI - blog.enterprisedna.co/detailed-ranking-example-using-dax-in-power-bi/ ***** Related Course Modules ***** Advanced DAX Combinations - portal.enterprisedna.co/p/advanced-dax-combinations Mastering DAX Calculations - portal.enterprisedna.co/p/mastering-dax-calculations DAX Formula Deep Dives - portal.enterprisedna.co/p/dax-formula-deep-dives ***** Related Support Forum Posts ***** Problem With Ranking (RANKX), Showing All Customers - forum.enterprisedna.co/t/problem-with-ranking-rankx-showing-all-customers/299 Dynamic RANKX With Other Category - forum.enterprisedna.co/t/dynamic-rankx-with-other-category/4108 Row Level Security And RANKX - forum.enterprisedna.co/t/row-level-security-and-rankx/2837 For more RANKX support queries to review see here…. - forum.enterprisedna.co/search?q=rankx

[@fahadnazir8080]

What a video to stumble upon. Wasted several hours on a topic and found the exact solution @9:50. Awesome work Sam and thank you!!

[@EnterpriseDNA]

Hi @fahadnazir8080, we’re glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming data skills and AI tutorials, and announcements. Cheers!

[@khawarahmed7492]

I had spent 3 days but wasn't able to come up with a solution for my calculations. Thanks Sam! You're a legend.

[@alyplayssafe2640]

thanks much. it has been uploaded 4yrs ago. however I'm still learning dax. this really helps me come up with the disired results I want. I rarely comment on youtube vids . but as a token of appreciation, I did whatever it needs to bring back the help you have provided. subscribed, thumbs up ❤❤🎉🎉

[@gerensp]

Okay... this absolutely saved me today on a completed group, sub-group, sub-segment rank challenge... Thanks Sam

[@ТатьянаЛустенкова-ч3щ]

I've spent so many days trying to find a solution! Thanks for a great video!

[@shairadoshitzky1077]

Great tutorial, after spending 2 days trying to figure it out, came across this video which had saved the day for me. Thank you

[@EnterpriseDNA]

Hi Shai, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!

[@DemonicSalt]

THANK YOU!! This was driving me insane.

[@cesarsaldana3429]

A very elegant solution to such a difficult and confusing challenge... greetings from Mexico

[@EnterpriseDNA]

Thanks for the continued support, Cesar!

[@HomeChef_Sandy]

Awesome. Thanks alot. This is really very very helpful. Same problem I was facing n because of you Im able to resolve it.

[@EnterpriseDNA]

Hi Sandeep, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

[@MucahitKatirci]

It was really helpful, thank you very much.

[@EnterpriseDNA]

Hi beren23632, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials and announcements. Cheers!

[@jorgepuentesmarquez6823]

Thanks a lot, Sam!!! you really clarified this function

[@EnterpriseDNA]

Hi Jorge, glad that this video is of help! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI video tutorials. Cheers!

[@johnmatta9577]

Couldn't you use just ALLSELECTED(Regions) instead of two allselected filters inside calculate? Another one on the update rank calculation: Can we use ALLEXCEPT(REGIONS, REGIONS[FULL COUNTY] Thanks Sam

[@kundansinha5603]

what if State and Region were from other tables with an active relationship with the Region table? This is where I am getting stuck! Any help is most welcomed

[@EnterpriseDNA]

Hi Kundan, It's a bit difficult to give recommendation without looking at the data structure, model and working of the PBIX file for the reference. You can reach out to us on our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZbin channel and LinkedIn group to keep posted on Power BI, Power Platform, and the Microsoft stack updates. Hoping you find this useful! Cheers, Enterprise DNA forum.enterprisedna.co/ www.linkedin.com/groups/12004506/

[@keybee]

Thank you!! You save me!!

[@josephpardo1427]

Hey Sam. I was wondering if you could do a video on Matrix formatting and how you have it set up? Thanks!

[@RajatSharma-tn6gf]

+1

[@CSH080291]

Many thanks for that! A great video as always! Country (Updated) = CALCULATE( RANKX(ALL(Regions[Full County]), [Total Sales], , DESC ), ALL(Regions), VALUES(Regions[Full County])) If you wanted to amend your above function to exclude blanks how would you do this within your VALUES()? I'm trying to amend your DAX to construct an ascending rank which omits blanks and can be filtered, but I'm struggling to figure out how you would tell the DAX to exclude empty values within the main reference data. My example so far omits them from the table but not the rank despite being the 1st value it's 16th in mine: SSR Rank (Static) = IF( NOT (ISBLANK(AA_Measures_SSR[SSR])), CALCULATE( RANKX(ALL('Institution Name (Complete)'), AA_Measures_SSR[SSR], , ASC, Skip), ALL('Institution Name (Complete)'), VALUES('Institution Name (Complete)'[Provider short name]))

[@EnterpriseDNA]

Hello Christian, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it and we're glad that you're liking our content. Well, just based on the measure you've provided we're not in a position to comment. Since it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

[@daniellopez46]

how do I rank all items except two on my list. I have survey data. Each person has multiple rows in my data; one per item answered per person. In my pivot table I have [Items] in rows and want to return blank on two values and rank all remaining items. I have an example btw but I posted a detailed example with my dax attempt and links to more info on another video and my comment disappeared.

[@EnterpriseDNA]

Hello Daniel lopez, thank you for posting your query onto our channel. Well it's always a little bit difficult to judge and provide the results without looking at the data structure, model and working of the PBIX file for the reference. And therefore we encourage you to please write back to us onto our Community Forum by providing the proper description of the problem that you're facing along with the PBIX file for the reference as well as the mock-up results that you're trying to achieve where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference. Still we're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA KZbin channel pertaining to this topic. Hoping you find this useful. Also make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. Happy Learning!!! forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA community.powerbi.com/t5/Community-Blog/Beginner-To-Advanced-RANKX-Techniques-For-Power-BI/ba-p/478066 blog.enterprisedna.co/advanced-dax-rankx-understanding-this-function-more-deeply/ blog.enterprisedna.co/deep-dive-into-rankx-dax-formula-concepts-in-power-bi/ blog.enterprisedna.co/dynamic-ranking-tables-in-power-bi/ blog.enterprisedna.co/group-customers-dynamically-by-their-ranking-wdax-in-power-bi/ blog.enterprisedna.co/detailed-ranking-example-using-dax-in-power-bi/ kzbin.info/www/bejne/jWbPq3yAadaMba8 kzbin.info/www/bejne/nomQpGSeqaeXo80 kzbin.info/www/bejne/fpy1Yn2Mr9KpiNk kzbin.info/www/bejne/Znm1kJtsjrmdsMU kzbin.info/www/bejne/fZixZp-th7qUp8U kzbin.info/www/bejne/fnvHh5mPoMubo6c

[@fael81br]

How to cope with calling table columns when ranking in a calculated table?

[@EnterpriseDNA]

Hello Rafael, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. We're providing few of the links of the articles from our blog posts as well as links of the videos from our Enterprise DNA KZbin channel pertaining to this topic. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful. Also, make sure that you're subscribed to our KZbin channel so that you don't miss out on any updates pertaining to the Power BI. You can also join our Power BI group on LinkedIn to receive latest updates on Power BI. Below are the links provided for the reference purposes. Cheers, Enterprise DNA forum.enterprisedna.co/ kzbin.info/door/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ kzbin.info/www/bejne/jWbPq3yAadaMba8 kzbin.info/www/bejne/eajFeaymhtJ1sJI kzbin.info/www/bejne/nomQpGSeqaeXo80 kzbin.info/www/bejne/fZixZp-th7qUp8U kzbin.info/www/bejne/fnvHh5mPoMubo6c kzbin.info/www/bejne/Znm1kJtsjrmdsMU kzbin.info/www/bejne/f4asYoBufbaYpMU

[@rid218]

Anyone still monitor this channel, I have a question

[@Wzxxx]

Great theory but in most cases ppl work with many dimension tables - it works only in particular scenario when columns come from one table. If one place columns from different dimensions there is some kind of crossing happening and many rank positions are visible which should not be visible. I don't understand why all tutorial present perfect scenarios which does not exist in real life. Ranx is is the most unfriendly function in DAX:( I also don't see any good explanation why the solution here works. The RANKX lookup table is always calculated against ALL counties, it doesn't matter that there is calculate with ALLSELECTED?