- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Grouping one value in two groups
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!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Are you expecting something like this?
Paul Zheng _ Community Support Tea
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@Anonymous
Are you expecting something like this?
Paul Zheng _ Community Support Tea
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@amitchandak Sorry dear all the data is sensitive can't share.
And how to separate it with comma? Can you please help with this?

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
11-19-2024 05:52 AM | |||
10-20-2024 09:47 PM | |||
08-22-2024 06:33 AM | |||
12-09-2024 01:07 AM | |||
11-18-2024 10:43 PM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |