Tag: Ranking DAX

Segmentation Of Your Data Based On Rankings – 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 try and segment our dimensions. We will segment some table in our data by the ranking of a dimension in that particular table. There’s a little bit to this but it’s a really amazing concept of how

Continue reading

Using Ranking DAX Measures To Extract Unique Insights In Power BI

In this example, I wanted to analyse something really practical. I wanted to work out the total sales of my top 3 salespeople based in any region. A really interesting insight, right? It might seem relatively intuitive but actually implementing this inside of Power BI is not that easy. You need to understand how to

Continue reading

Discover Unique Insights Using TOPN in Power BI

In this video, I wanted to find an insight that was really unique, and hugely valuable for business. I wanted to know the best-selling day for every single product. Not only that, I wanted to be able to look dynamically into any store and analyse the best-selling day for every single product that each store

Continue reading

Create Automated Lists Based On Ranking Calculations in Power BI

You might find a situation where across a range of different metrics you actually want to show the TopN of something. In the example I run through in this tutorial video, I’m going to show how dynamically we can place a filter on our set of clients that is determined by the ranking in a

Continue reading

Change Your Visuals Size By Ranking Logic in Power BI using DAX

Have you ever wanted to create a visualization which changes based on any ranking selection you could make? In this video, I show you exactly how to do it. Think of a scenario where you want to showcase your top 20 clients. Pretend you’re in a meeting saying, “These are the clients that are contributing

Continue reading