Tag: Ranking DAX

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

Showcase The Top Result Name Within A Card Visualization Using Power BI

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

Continue reading

Deep Dive Into RANKX – DAX Formula Concepts In Power BI

Deep Dive Into RANKX - DAX Formula Concepts In Power BI

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

Continue reading

Creating Dynamic Ranking Tables Using RANKX In Power BI

Creating Dynamic Ranking Tables Using RANKX In Power BI

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,

Continue reading

Segmentation Of Your Data Based On Rankings – Advanced Analytical Technique For Power BI

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

Continue reading