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,
In this example we’re going to get quite advanced in Power BI using DAX. We are going to try and segment our dimensions. We will segment some table in our data by the ranking of a dimension in that particular table. There’s a little bit to this but it’s a really amazing concept of how
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
