Tag: DAX Functions

Using The ALL Function In Power BI For High Quality Insights

This video tutorial shows you how you can use the ALL Function in Power BI to showcase unique insights. Think about this one from a deeper analytical perspective. We’re going to dive into the average order size for sales we may be making across a variety of different products. If you’re selling to a lot

Continue reading

Create Dynamic Lists of Dimensions using DAX in Power BI

Have you ever wanted to showcase the top three, five, or ten best results across a particular dimension? Well, in this video I’m going to show you exactly how you can do that with a specific example. The example we’re going to work through is one where I want to find my top three salespeople

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

Advanced Logic Within DAX Iterating Functions – Detailed Example

I want to dive here into iterating functions within the DAX language in Power BI. The reason why I want to spend some time showing you what you can do inside of iterating functions is because it’s such an important concept that you need to learn very well. You might have only just completed some

Continue reading