Tag: Power BI Top N

When To Use TOPN In Power BI – A DAX Formula Review

By Sam McKay, CFA on August 6, 2020August 4, 2021

This tutorial will review how to use TOPN as a virtual ranking function to generate interesting insights based on ranking logic in Power BI. You may watch the full video of this tutorial at the bottom of this blog. Using TOPN as a virtual ranking function allows you to dynamically produce the top and bottom

Posted in: Power BI Top N, Ranking Logic, Top and Bottom in Power BI, Top and Bottom Results, TOPN and CALCULATE, TOPN FUNCTION, topn function power bi, TOPN Power BI, Virtual Ranking

Data Modeling DAX Enterprise DNA Power BI

Automatically Find Your Top 3 Salespeople Per Region Using DAX In Power BI

By Sam McKay, CFA on December 4, 2019May 11, 2022

Create Dynamic Lists of Dimensions using DAX in Power BI

There’s so much you can do with DAX in Power BI, and one of these things is for you to be able to find your top 3 salespeople for each region automatically. You may watch the full video of this tutorial at the bottom of this blog. Picture this too familiar scenario…. You are in

Posted in: CALCULATE and TOPN, DAX Calculations, Dynamic Top N Slicer, Dynamic TopN and Other, Power BI DAX, Power BI show Top 3, Power BI Top N