Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Group customers - DAX question

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Great thanks Anonymous 
    This will definately help me!