https://community.fabric.microsoft.com/t5/Developer/TopN-Other/m-p/1497692#M26486 <P>Hi,</P><P>In the first screenshot in the table below ,CountryRankAmended and TOP4 are the calculated columns with the below formula&nbsp;</P><DIV><DIV><SPAN>CountryRank amended = RANKX(ALLSELECTED(user_first_deposit[country]),CALCULATE(SUM(user_first_deposit[usd_amount])))</SPAN></DIV></DIV><DIV><DIV><SPAN>TOP4 = IF( [CountryRank amended] &lt;= 4, MAX(user_first_deposit[country]), "other")</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Now i want to group the other together and show in one line as in the second screenshot . Please assist&nbsp;</SPAN></DIV></DIV><P>1 St Screenshot&nbsp;</P><P><img /></P><P>2nd Screenshot&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 17 Nov 2020 02:10:43 GMT burnaNayak 2020-11-17T02:10:43Z https://community.fabric.microsoft.com/t5/Developer/TopN-Other/m-p/1497692#M26486 <P>Hi,</P><P>In the first screenshot in the table below ,CountryRankAmended and TOP4 are the calculated columns with the below formula&nbsp;</P><DIV><DIV><SPAN>CountryRank amended = RANKX(ALLSELECTED(user_first_deposit[country]),CALCULATE(SUM(user_first_deposit[usd_amount])))</SPAN></DIV></DIV><DIV><DIV><SPAN>TOP4 = IF( [CountryRank amended] &lt;= 4, MAX(user_first_deposit[country]), "other")</SPAN></DIV><DIV>&nbsp;</DIV><DIV><SPAN>Now i want to group the other together and show in one line as in the second screenshot . Please assist&nbsp;</SPAN></DIV></DIV><P>1 St Screenshot&nbsp;</P><P><img /></P><P>2nd Screenshot&nbsp;</P><P><img /></P><P>&nbsp;</P> Tue, 17 Nov 2020 02:10:43 GMT https://community.fabric.microsoft.com/t5/Developer/TopN-Other/m-p/1497692#M26486 burnaNayak 2020-11-17T02:10:43Z https://community.fabric.microsoft.com/t5/Developer/TopN-Other/m-p/1501185#M26510 <P>Hi&nbsp;<a href="javascript:void(0)" data-lia-user-mentions="" data-lia-user-uid="268671" data-lia-user-login="burnaNayak" class="lia-mention lia-mention-user">burnaNayak</a>&nbsp;,</P> <P>&nbsp;</P> <P>please refer to my .pbix file.</P> <P><img /></P> <P>&nbsp;</P> <P>Best regards,<BR />Lionel Chen</P> <P>If this post<SPAN>&nbsp;</SPAN><STRONG><I>helps</I></STRONG>, then please consider<SPAN>&nbsp;</SPAN><STRONG><I>Accept it as the solution</I></STRONG><SPAN>&nbsp;</SPAN>to help the other members find it more quickly.</P> Wed, 18 Nov 2020 08:31:16 GMT https://community.fabric.microsoft.com/t5/Developer/TopN-Other/m-p/1501185#M26510 v-lionel-msft 2020-11-18T08:31:16Z