Tag: RANKX Function

Ranking Analysis In Power BI: Advanced Insights From Combined Data Sets

In this tutorial, I’m going to show you some advanced ranking analysis in Power BI. As an example, I’m going to use the report that I submitted for the 10th Power BI Challenge on the Enterprise DNA forum. I have discussed the other pages in this report in other tutorials. For now, I would like

Continue reading

Ranking Visualization In Power BI – Dynamic Visual

In this blog post, I want to teach you how to show your customers moving through groups over time in a dynamic way. You can do this ranking visualization in Power BI using a unique slicer. You may watch the full video of this tutorial at the bottom of this blog. When I click This

Continue reading

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. You

Continue reading

Advanced DAX Functions: Calculating Profit Contribution

In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. You may watch the full video of this tutorial at the bottom of this blog. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. Calculating Total Profits

Continue reading

Segmenting Dimensions Based On Ranking – Advanced Analytical Technique For Power BI

In this example, we’re going to get quite advanced in Power BI using DAX. We are going to focus on segmenting dimensions based on its ranking on that particular table. You may watch the full video of this tutorial at the bottom of this blog. This is an amazing concept of how you can utilize

Continue reading