Tag: DAX Dynamic Ranking

Power BI Dynamic Ranking By Group

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

Continue reading

Isolating The Top Or Bottom Outcomes Using RANKX In Power BI

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

Continue reading