https://community.fabric.microsoft.com/t5/Visual-Calculations-Gallery/Table-matrix-with-TopN-and-others/m-p/4827378#M8 <P>This one is a bit tricky but solves a common wish of showing af table with the Top number of x plus others.</P><P>&nbsp;</P><P>There are several tricks involved in this one - first we use a matrix and add the numeric fieldparameter value to the rows and then the attribute we want to group the items by - hide the +/- icon and then we use different visual calculations to show the attributes value if is matches the rank number of the product.</P><P>&nbsp;</P><P>Visual calculation functions used:</P><P>&nbsp;</P><P>EXPAND</P><P>RANK</P><P>ISINSCOPE<BR />RUNNINGSUM</P><P>&nbsp;</P><P>A large dataset will affect the performance and you might want to consider alternatives</P><P>&nbsp;</P><P>Enjoy visual calcs</P><P>&nbsp;</P><P>Erik</P> Tue, 16 Sep 2025 10:46:28 GMT donsvensen 2025-09-16T10:46:28Z https://community.fabric.microsoft.com/t5/Visual-Calculations-Gallery/Table-matrix-with-TopN-and-others/m-p/4827378#M8 <P>This one is a bit tricky but solves a common wish of showing af table with the Top number of x plus others.</P><P>&nbsp;</P><P>There are several tricks involved in this one - first we use a matrix and add the numeric fieldparameter value to the rows and then the attribute we want to group the items by - hide the +/- icon and then we use different visual calculations to show the attributes value if is matches the rank number of the product.</P><P>&nbsp;</P><P>Visual calculation functions used:</P><P>&nbsp;</P><P>EXPAND</P><P>RANK</P><P>ISINSCOPE<BR />RUNNINGSUM</P><P>&nbsp;</P><P>A large dataset will affect the performance and you might want to consider alternatives</P><P>&nbsp;</P><P>Enjoy visual calcs</P><P>&nbsp;</P><P>Erik</P> Tue, 16 Sep 2025 10:46:28 GMT https://community.fabric.microsoft.com/t5/Visual-Calculations-Gallery/Table-matrix-with-TopN-and-others/m-p/4827378#M8 donsvensen 2025-09-16T10:46:28Z