RANKX Considerations - Power BI & DAX Formula Concepts
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/power-bi-reso...
FREE - 60 Page DAX Reference Guide Download - https://enterprisedna.co/dax-formula-...
Learn more about Enterprise DNA - http://www.enterprisedna.co/
Enterprise DNA Membership - https://enterprisedna.co/membership
Enterprise DNA Events - https://enterprisedna.co/enterprise-d...
**** Related Links****
Using Dynamic Visuals On Ranking Based Parameters In Power BI - https://blog.enterprisedna.co/make-yo...
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...
Watch video RANKX Considerations - Power BI & DAX Formula Concepts online, duration hours minute second in high quality that is uploaded to the channel Enterprise DNA 29 March 2018. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 53,922 times and liked it 571 visitors.
