I’m going to show you how to create custom tiebreakers when using RANKX in Power BI. Getting a tie in a critical portion of RANKX results is a common scenario. There are a number of tiebreakers you can use but it’s important to choose the one that makes the most sense for each situation. The
This tutorial will go through an advanced example on the DAX function RANKX in Power BI. This is a breakout session from the Learning Summit Workshop in Enterprise DNA Online. The RANKX function gives you valuable insights when you use it for a range of different contexts in your report page. However, it can also
In this tutorial, we’ll look at a unique technique inside Power BI that allows us to create dynamic ranking tables using the RANKX function. What are Dynamic Ranking Tables? Dynamic Ranking Tables showcase a range of information dynamically in a table, but the information shown is based off a specific ranking on a singular calculation.
In this tutorial, we are going to dive into how to utilize ranking techniques effectively in Power BI. Sometimes you don’t want to show all the results from your data in your visualization. Sometimes you only want to see the top or the bottom results, for example the top five or the bottom seven. To
RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and in how it actually works when running a calculation in a particular context (for example a table or chart inside Power BI). What you don’t want with RANKX DAX function is to start receiving results and not really