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 without registration, duration hours minute second in high quality. This video was added by user Enterprise DNA 29 March 2018, don't forget to share it with your friends and acquaintances, it has been viewed on our site 53,922 once and liked it 571 people.