One of my previous blog post introduces how to find the items which are ranked in top n for multiple periods, using the INTERSET and TOPN functions. However, that approach needs to hard-code the periods and the number of top items in the DAX scripts. This blog post introduces an approach that allows users to … Continue reading DAX – Find the Items Ranked in Top n for Multiple Periods (with Dynamic Slicing) →

Update - I have suggested another approach here that allows users to dynamically specify the periods and the number of top items to evaluate, using the interactive dashboard slicers. When analysing the best performers against a specific measure such as the best sold products, we sometimes need to take multiple periods into consideration. For example, … Continue reading DAX – Find the Items Ranked in Top n for Multiple Periods →

Problem We can use the DAX RANKX function to return the rank of an item based on one of its numerical attribute. For example, we can create a measure using RANKX function to calculate the ranks of the product categories based on the order quantity within the product categories. This measure will normally work fine … Continue reading DAX – Ranking with Hierarchy Drill-Down →

When building a Power BI report page for analysing data by a specific dimension (e.g., customer, product and category), we often need to dynamically show the title of currently selected item(s). One trick to show the title based on the current filter context is to use Multi-Row Card visual (we can also use the single … Continue reading DAX – Dynamically Showing Title by Slicer in Power BI →