https://community.fabric.microsoft.com/t5/Developer/TopN-Other/m-p/1501185#M26510 <P>Hi&nbsp;<a href="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/268671">@burnaNayak</a>&nbsp;,</P> <P>&nbsp;</P> <P>please refer to my .pbix file.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="v-lionel-msft_0-1605688220798.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/399199i7CFEEDCCB02522F8/image-size/medium?v=v2&amp;px=400" role="button" title="v-lionel-msft_0-1605688220798.png" alt="v-lionel-msft_0-1605688220798.png" /></span></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 v-lionel-msft 2020-11-18T08:31:16Z 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><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="burnaNayak_1-1605578811685.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/398048iE12C95779E205625/image-size/medium?v=v2&amp;px=400" role="button" title="burnaNayak_1-1605578811685.png" alt="burnaNayak_1-1605578811685.png" /></span></P><P>2nd Screenshot&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="burnaNayak_0-1605578781121.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/398047i58688D8E6C994ECB/image-size/medium?v=v2&amp;px=400" role="button" title="burnaNayak_0-1605578781121.png" alt="burnaNayak_0-1605578781121.png" /></span></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="https://community.fabric.microsoft.com/t5/user/viewprofilepage/user-id/268671">@burnaNayak</a>&nbsp;,</P> <P>&nbsp;</P> <P>please refer to my .pbix file.</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="v-lionel-msft_0-1605688220798.png" style="width: 400px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/399199i7CFEEDCCB02522F8/image-size/medium?v=v2&amp;px=400" role="button" title="v-lionel-msft_0-1605688220798.png" alt="v-lionel-msft_0-1605688220798.png" /></span></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