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




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

New Kudos Received Badges Coming

New Kudos Received Badges Coming

Kudos to you if you earned one of these! Check your inbox for a notification.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (1,639)