Creating new column with custom grouping

[Yuiitsu]

Hi Experts

I would like to create a new column to group my customer base on certain rules. Please take a look at the example I created below

Customer	Item Purchased
AAA	GT
BBB	GT
AAA	AT
CCC	AT
CCC	FT
DDD	GT
DDD	GT
AAA	HT
CCC	HT

I want the rule to be like this:

New column= if customer = AAA = "AAA",

if customer = BBB = "BBB"

anything else will be grouped as "others"

Can anyone tell me how to set this formula? 

Let me know if my request is confusing. 

Thanks!

[v-alq-msft · Accepted solution]

Hi, @Yuiitsu 

Based on your description, you may create a meausre or a column as follows.

Result = 
var _customer = SELECTEDVALUE('Table'[Customer])
return
IF(
    ISFILTERED('Table'[Customer]),
    IF(
        _customer in {"AAA","BBB"},
        _customer,
        "others"
    )
)

Result Column = 
IF(
    'Table'[Customer] in {"AAA","BBB"},
    'Table'[Customer],
    "others"
)

Result:

Best Regards

Allan

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

[Yuiitsu]

Hi Experts

I found out that I could just right click the column and add new group.

It is so much easier!

Thanks alot for all the info guys!

[amitchandak]

Try a new column

New column = switch( true(),
[customer] = "AAA", "AAA",
[customer] = "BBB", "BBB",
"Others"
)

Also check : https://radacad.com/grouping-and-binning-step-towards-better-data-visualization