https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/TOPN-function-in-Power-BI/m-p/3306312#M661 <P>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<BR /><BR />Sometimes you need to see how much of the whole the Top 5 items account for<BR /><BR />Using the TOPN function in DAX you can create a measure that does just that<BR /><BR />This guide shows you how<BR /><BR /><A href="https://www.selectdistinct.co.uk/2023/06/28/topn-in-power-bi/" target="_blank">TOPN in Power BI - Select Distinct</A><BR /><BR /><img /><BR /><BR /><BR /></P><P><SPAN class="videoUrl hidden">watch?v=KbQJZeszfoc</SPAN></P> Wed, 28 Jun 2023 13:32:47 GMT S_Harrison_SD 2023-06-28T13:32:47Z https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/TOPN-function-in-Power-BI/m-p/3306312#M661 <P>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<BR /><BR />Sometimes you need to see how much of the whole the Top 5 items account for<BR /><BR />Using the TOPN function in DAX you can create a measure that does just that<BR /><BR />This guide shows you how<BR /><BR /><A href="https://www.selectdistinct.co.uk/2023/06/28/topn-in-power-bi/" target="_blank">TOPN in Power BI - Select Distinct</A><BR /><BR /><img /><BR /><BR /><BR /></P><P><SPAN class="videoUrl hidden">watch?v=KbQJZeszfoc</SPAN></P> Wed, 28 Jun 2023 13:32:47 GMT https://community.fabric.microsoft.com/t5/Webinars-and-Video-Gallery/TOPN-function-in-Power-BI/m-p/3306312#M661 S_Harrison_SD 2023-06-28T13:32:47Z