Showing results for 
Search instead for 
Did you mean: 
lpowell Visitor

Add custom grouping

I have a need to group department information by commonly referred names non-existent in the data.  To use a grocery analogy, if I had commonly referred names of:

  • Produce
  • Bakery
  • Meat

Departments of: 

Department Number - Department Name

1234 - International Produce

1235 - Local Grown Veggies

1236 - Organic 

1237 - Full of Pesticides

2345 - Fresh Baked

2456 - Day Old

2567 - Baked to Order

3456 - Pre-Packaged

3567 - Cut to Order

3678 - Ready for the Grill


How would I add the commonly referred names then group the department information accordingly.




Larry Powell



Super User
Super User

Re: Add custom grouping

@lpowell Take a look at this DAX pattern. It looks like Static segmentation is what you are after.

Near SE WI? Join our PUG Milwaukee Brew City PUG
Super User
Super User

Re: Add custom grouping

You could have a look at my Power BI lookup blog article here, this covers the topic pretty well.

I have book! Learn Power BI from Packt

Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!

Moderator v-sihou-msft

Re: Add custom grouping



In this scenario, it's better to add a category id column in both tables, and build the relationship based on this id column. You can hardly populate the commonly referred names based on Department Name matching only.



Helpful resources

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Top Kudoed Authors
Users Online
Currently online: 395 members 3,407 guests
Please welcome our newest community members: