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

New Ranks and Rank Icons in 2020

New Ranks and Rank Icons in 2020

Read the announcement for more information!

New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

November 2019 Community Highlights

November 2019 Community Highlights

Get an overview of the events and great community content from November.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)