Item Mix Visualization

Hi Anonymous

I'm keen to understand more about what you mean about selecting combinations.

Feel free to DM me with a PBIX file with more detail so I can help more.

Hey Anonymous

maybe you are looking for something like this, taken from this little example

The table showh a normal sales table, I created a calculated column "Item_Mix" that concatenates the items purchased by each customer, this is the dax statement:

Item_Mix = CALCULATE(
    CONCATENATEX(VALUES(Sales[Item]),'Sales'[Item],","),
    ALLEXCEPT('Sales',Sales[Customer_ID])
)

Using a calculated column enables you to use this column in visuals or as a slicer.

The problem here is the underlying assumption, that the concatenation can be performed as a calculated column. Meaning that the calculation can become much more complex if it has to consider more columns.

A calculated column is necessary due to the effect, that measures currently can not be used on axis or as content for a slicer - this is for a couple of reasons and i would assume that this will not change in the near future.

Hope this helps

Tom

Hi Anonymous,

---

i was hoping to be able to use a treemap so you could select the combinations better and accounting for these different combinations would happen behind the scenes automatically like when im selecting different regions for sales data across the states

---

Is your expected result similar like below?

If so, you can firstly use the formula provided by Phil_Seamark above to add a calculate column to your table.

mix = 'Table1'[Item1] & "," & 
		 'Table1'[Item2] & "," &
		 'Table1'[Item3] & "," & 
		 'Table1'[Item4]

Then, you can use the new create calculate column as Group on the Treemap, and use the four Item column as Slicers to get your expected result on the report.

Here is the sample pbix file for your reference. :smileyhappy:

Regards