topic Re: Group customers - DAX question in DAX Commands and Tips

Group customers - DAX question

Anonymous — Thu, 12 Aug 2021 12:36:32 GMT

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

Re: Group customers - DAX question

Anonymous — Thu, 12 Aug 2021 13:09:32 GMT

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

Re: Group customers - DAX question

Anonymous — Thu, 12 Aug 2021 14:45:37 GMT

Great thanks Anonymous
This will definately help me!