https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/689258#M567 <P>No it doesn't work as Rank results in 1 for all the products.</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 12 May 2019 16:16:48 GMT raviku 2019-05-12T16:16:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/688893#M564 <P>i have a table where i 2 columns Product and sales. I need to show first 5 rows dynamically and rest 5 products as others as sum of sales. i Tried usingg RankX but couldnt achieve it can you anyone help out.</P><TABLE border="0" cellspacing="0" cellpadding="0"><TBODY><TR><TD>Product</TD><TD>Sales</TD></TR><TR><TD>A</TD><TD>3</TD></TR><TR><TD>B</TD><TD>4</TD></TR><TR><TD>C</TD><TD>1</TD></TR><TR><TD>D</TD><TD>5</TD></TR><TR><TD>E</TD><TD>7</TD></TR><TR><TD>F</TD><TD>8</TD></TR><TR><TD>G</TD><TD>12</TD></TR><TR><TD>H</TD><TD>9</TD></TR><TR><TD>I</TD><TD>2</TD></TR><TR><TD>K</TD><TD>10</TD></TR></TBODY></TABLE> Fri, 10 May 2019 18:36:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/688893#M564 raviku 2019-05-10T18:36:46Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/689247#M566 <P><a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="90994" data-lia-user-login="raviku" class="lia-mention lia-mention-user">raviku</a> did you looked at this <A href="https://community.powerbi.com/t5/Desktop/Top-10-Other/m-p/51282#M20561" target="_self">post</A>?</P> <P>&nbsp;</P> Sun, 12 May 2019 15:15:56 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/689247#M566 parry2k 2019-05-12T15:15:56Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/689258#M567 <P>No it doesn't work as Rank results in 1 for all the products.</P><P>&nbsp;</P><P>&nbsp;</P> Sun, 12 May 2019 16:16:48 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/689258#M567 raviku 2019-05-12T16:16:48Z https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/693919#M625 <P>Even that doesnt work</P> Fri, 17 May 2019 16:04:46 GMT https://community.fabric.microsoft.com/t5/DAX-Commands-and-Tips/Show-Top-5-values-and-rest-others-rows-sum-as-others/m-p/693919#M625 raviku 2019-05-17T16:04:46Z