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
Tag: DAX formula
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
Sometimes calculating averages per day in your Power BI reports isn’t actually enough. You might run into a scenario where you only actually sell during weekdays. You might be a retailer or a restaurant where you only sell in a specific period of days. Now, if you go and run an averaging pattern in Power
So we’re going to really dive into some problem-solving here. This is some really great stuff that you can do with Power BI, but if we just step back for a moment, the key here is, first of all, you’ve got to be able to think analytically. And that’s what I want to do initially.