Take count of measure objects which captures colours information.
This is a solution, but may not be the best solution depending on your use case.
- The easiest solution would be if your data was in wide-format, where each reference color was its own column. That way you could concatenate your columns to create a composite of the combinations. This would allow you to aggregate properly.
- If you cannot get your data into wide-format, you can simulate wide-format. That is what I have done in the attached solution.
I have recreated your issue:
I am then able to produce the following visualization, which shows the count for each combination:
This is pretty hacked together, but here are the basic steps:
1) Create a calculated field for each of your colors. This is how we simulate wide-format.
2) Create a calculated field called "Combination". This is a level of detail expression that creates your unique combinations. I have gone to the [Order Number] of detail.
3) Create a new sheet. Turn-off Aggregate Measures under the Analysis tools. When you drag combinations to the rows shelf, change it to Attribute. Drag Order Number to the detail shelf, and add it to the tooltip to see which order numbers make up the combination. When you drag combinations to the columns shelf, change it to be continuous.
See attached Workbook for more information.
Combinations Workbook.twbx 36.5 KB