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
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
A recent question came out of the Enterprise DNA Support Forum where a member needed to work out what was the top value that they had for a particular result. You can review the entire forum post here – Product Name as Measure for Highest Sales Product They didn’t require just any value. They actually
RANKX is a very unique DAX function that requires a deeper level of thinking around its logic and also in how it actually works when running a calculation in a particular context (for example a table or chart inside of Power BI). Each different parameter within the RANKX function can change the way in which it
I really like using this unique technique inside of Power BI to create dynamic ranking tables. What do I mean by Dynamic Ranking Tables? Dynamic tables showcase a range of information dynamically in a table, but the information that are showing are based off a specific ranking on a singular calculation. In this particular example,
