Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
We all know Power BI has a TOP N filter built in, giving the ability to filter to top 5 or so items, but it has its limitations
Sometimes you need to see how much of the whole the Top 5 items account for
Using the TOPN function in DAX you can create a measure that does just that
This guide shows you how
TOPN in Power BI - Select Distinct
watch?v=KbQJZeszfoc