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)