Grouping one value in two groups

[Anonymous]

I am trying to group data of a column. I want to group one value in two groups, how to do it?

For Example:  I am creating new column of group called Z. The column has multiple cities name of USA.

Now I am grouping them into two -A and B.

Now city "San Jose" need to be grouped as A and B also. But I am able to put it in group A OR group B. Here I want it to put in A&B both. What is the solution?

Please help!

[V-pazhen-msft · Accepted solution]

@Anonymous 
Are you expecting something like this?

Paul Zheng _ Community Support Tea

[Anonymous]

@V-pazhen-msft I think this might work for small data.

For large data the nested IF with be very lengthy.

This solves my problem. I have to create a big DAX for it!

Thanks.

[amitchandak]

@Anonymous , Have two columns One for A and one for B

Have a city table with the group where you have rows for both A and B, you need to create a many to many birection join to filter

[Anonymous]

@amitchandak Thanks for your reply.

1.Imagine I have 100s of rows of data. I cannot create different columns for issues like this. The number of columns will get increasing for large data.

2. I want to use this column Z as slicer to filter data according to the grouping.

[amitchandak]

@Anonymous , You can have comma separated.

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

@amitchandak Sorry dear all the data is sensitive can't share.

And how to separate it with comma? Can you please help with this?