In this blog, I’ll be discussing some more advanced DAX functions to demonstrate what’s possible in Power BI. This tutorial will teach you how to visualize the profit contribution of different client tiers using advanced DAX functions. Calculating Total Profits I’m going to start by creating a new measure and renaming it as Total Costs.
Tag: Dynamic Ranking in Power BI
Dynamic ranking in Power BI can be tricky if you don’t fully understand how it works. You might think that you got the formula right, but then you’d be surprised why you’re not getting the correct results. The key is to really understand the context that you’re working on and simplify your formulas. Knowing your
Today we are going to focus on a technique used in the ‘Time Intelligence’ demo in the ‘Scenarios’ section of the Enterprise DNA showcase. I’ll show you how you can use RANKX in Power BI to get your top or bottom results. Being able to show dynamically the top or bottom outcomes of any calculations