Group customers - DAX question

[Anonymous]

Hello,

I have a table visual with Customer Names and a measure "Total Sales %" which basically divides the Total Sales with the global Total Sales.
You get something like this:

I would like to group all customers that have <1% of "Total Sales %" in 1 single group called "Others".

How should I tackle this problem?

Kind regards,

Kevin

[Anonymous]

Great thanks @Anonymous 
This will definately help me!

[Anonymous · Accepted solution]

This is not an easy task in PBI. You can see how such things are done here: https://youtu.be/nVvlEHKr_0o