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...
Смотрите видео RANKX Considerations - Power BI & DAX Formula Concepts онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Enterprise DNA 29 Март 2018, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 53,922 раз и оно понравилось 571 людям.