By Andrew Gould
Download files here https://www.wiseowl.co.uk/power-bi/videos/dax-powerbi/dax-rankx-function/
Full DAX playlist https://youtube.com/playlist?list=PLNIs-AWhQzclPj5BGcckuyrOVqRD-7rIX
If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos you can join this channel to get access to perks:
https://www.youtube.com/channel/UCbi5G5PjWBaQUFy7XU_O7yw/join
Or you can click this link https://www.wiseowl.co.uk/donate?t=1 to make a donation. Thanks for watching!
This video explains how to use the RANK function to rank values in DAX measures. You'll learn about some of the differences between RANK and RANKX. You'll see how to control tied results with the SKIP and DENSE settings. You'll learn how to use the ORDERBY function to rank a category on multiple values. You'll see how to treat BLANK values in a ranking, including how to hide blanks completely. You'll use the ISINSCOPE function to decide which measure to return in a visual with multiple category fields. Finally, you'll learn how to solve a problem involving sort by columns in your data model.
Chapters
00:00 Topic list
00:37 A Recap of RANKX
03:34 Using the RANK Function
05:54 Another Basic RANK Example
07:55 Controlling Tied Results
09:38 Ranking on Multiple Values
13:14 Dealing with Blanks
17:16 Ranking Different Levels in a Visual
20:02 Combining Ranks in a Single Measure
21:47 Changing the Hierarchy Order
24:55 A Problem with Sort By Columns
Visit https://www.wiseowl.co.uk for more online training resources in Microsoft Excel, Microsoft Power BI, DAX, VBA, Python, Visual C#, Microsoft SQL Server, SQL Server Reporting Services SSRS, SQL Server Integration Services SSIS, Microsoft Access and more!