Tag: Topn

Advanced Analytics In Power BI: Threshold Triggers Using DAX

In this tutorial, I run through an advanced analytics technique in Power BI called Threshold Triggers. With this analytical concept in Power BI, you can set certain thresholds or certain trigger points via a supporting table in your data model. Once you’ve added this supporting table and it’s inputs, you can then run logic through

Continue reading

Extracting Unique Insights In Power BI Using Ranking DAX Measures

In this blog, I showcase ranking DAX measures to analyse something really practical and get amazing insights inside Power BI. It’s 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

Continue reading

Discover Unique Insights Using Power BI TOPN Function

In this video, I wanted to find an insight that was really unique, and hugely valuable for business. Here, I used the Power BI TOPN function. 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

Continue reading

Ranking Insights Using TOPN In Power BI

In this article, we will explore how we can use the TOPN function in Power BI. You will really enjoy seeing the immense amount of ways that you can utilize this function. TOPN is such a powerful function and there are so many little nuances in how it operates in different contexts. I’m going to

Continue reading