In this example I showcase the key tips to understanding the DAX formula RANKX.
There are a number of concepts to understand well to make sure the results you expect are created.
I run through the most important concept which is 'CONTEXT'. Once you nail this then you can really understand how to use this formula effectively.
Good luck!
**** Video Details ****
0:43 Sample Basic RANKX Scenario
1:14 Using The ALL Function Within RANKX DAX Calculation
3:01 Sample Complex RANKX Scenario
4:37 Using the CROSSJOIN Function
**** Learning Power BI? ****
FREE COURSE Ultimate Beginners Guide To Power BI http://portal.enterprisedna.co/p/ulti...
FREE COURSE Ultimate Beginners Guide To DAX http://portal.enterprisedna.co/p/ulti...
FREE Power BI Resources http://enterprisedna.co/powerbireso...
FREE 60 Page DAX Reference Guide Download https://enterprisedna.co/daxformula...
Learn more about Enterprise DNA http://www.enterprisedna.co/
Enterprise DNA Membership https://enterprisedna.co/membership
Enterprise DNA Events https://enterprisedna.co/enterprised...
**** Related Links****
Using Dynamic Visuals On Ranking Based Parameters In Power BI https://blog.enterprisedna.co/makeyo...
Find Top Customers Using RANKX In Power BI https://blog.enterprisedna.co/detaile...
Master Virtual Tables in Power BI Using DAX https://blog.enterprisedna.co/working...
**** Related Course Modules****
DAX Formula Deep Dives http://portal.enterprisedna.co/p/dax...
Advanced DAX Combinations http://portal.enterprisedna.co/p/adva...
Mastering DAX Calculations http://portal.enterprisedna.co/p/mast...
**** Related Support Forum Posts****
Problem with Ranking (RankX), Showing all Customers https://forum.enterprisedna.co/t/prob...
RANKX Vs TOPN what is the difference? https://forum.enterprisedna.co/t/cumu...
Dynamic RANKX with Other Category https://forum.enterprisedna.co/t/dyna...
For more rankx support queries to review see here https://forum.enterprisedna.co/search...