Tag: RANKX

RANKX In Power BI – Developing Custom Tiebreakers

Develop Custom Tiebreakers in RANX Power BI and DAX

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

Continue reading

A Deeper Understanding Of Advanced RANKX

Advanced RANKX - How To Understand This Function More Deeply

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

Continue reading

Creating Dynamic Ranking Tables Using RANKX In Power BI

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.

Continue reading

Show Top Or Bottom Results Using Ranking In Power BI

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

Continue reading

RANKX Considerations – Power BI And DAX Formula Concepts

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

Continue reading