Segmentation based on multiple criteria across tables

Power BI
1

Has anyone worked out how to do segmentation on more than one dimension table?

This is a good example of using one dimension for DAX segmentation:

I am searching for a solution to regroup dimensions based on multiple criteria, across two tables. A
“Sales” example would be displaying Customer Groups (Grouped into global Top, Mid, Low by value), and Products groups (Grouped by global Top, Mid, Low value).

  • Customers from the Customer table (Customer ID | Customer Name)
  • Products from the product table (Product ID | Product Name)
  • Values from the value table (Customer ID | Product ID | Value)

Any ideas?

2

Hi @123kerrod

To help us further visualize your issue, could you please provide as many as you can of:

  • Your work-in-progress PBIX file, using sanitized data if necessary
  • Your dataset as an Excel file (again, sanitized if necessary)
  • A detailed mock-up (marked-up screenshot and/or Excel file) of your desired outcome.

Greg

3

Thanks for posting your question @123kerrod. To receive a resolution in a timely manner please make sure that you provide all the necessary details on this thread.

Here is a potential list of additional information to include in this thread; demo pbix file, images of the entire scenario you are dealing with, screenshot of the data model, details of how you want to visualize a result, and any other supporting links and details.

Including all of the above will likely enable a quick solution to your question.

4

Hi @123kerrod, we’ve noticed that no response has been received from you since the 22nd of October. We just want to check if you still need further help with this post? In case there won’t be any activity on it in the next few days, we’ll be tagging this post as Solved. If you have a follow question or concern related to this topic, please remove the Solution tag first by clicking the three dots beside Reply and then untick the checkbox. Thanks!

5

Hi @123kerrod, due to inactivity, we have tagged this post as SOLVED. If you feel the need to activate the post, we suggest creating a new topic to get a better response from the community. Thanks!