Forum Discussion

burnaNayak's avatar
burnaNayak
Regular Visitor
5 years ago
Solved

TopN + Other

Hi,

In the first screenshot in the table below ,CountryRankAmended and TOP4 are the calculated columns with the below formula 

CountryRank amended = RANKX(ALLSELECTED(user_first_deposit[country]),CALCULATE(SUM(user_first_deposit[usd_amount])))
TOP4 = IF( [CountryRank amended] <= 4, MAX(user_first_deposit[country]), "other")
 
Now i want to group the other together and show in one line as in the second screenshot . Please assist 

1 St Screenshot 

2nd Screenshot 

 

Show and Tell

1 Reply

  • v-lionel-msft's avatar
    v-lionel-msft
    Community Support
    5 years ago

    Hi burnaNayak ,

     

    please refer to my .pbix file.

     

    Best regards,
    Lionel Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.