Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Item Mix Visualization

so i have 4 columns of binary data    i want to be able to filter through the combinations of the 4 how can i do that? ie if i have product 1 and product 2 vs having all 4 products?   when i t...
Anonymous's avatar
Anonymous
Not applicable
9 years ago

i have 4 items i need combinations of it sounds like this would be listing out all 24 combinations for separate revenue 

 

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

TomMartens's avatar
TomMartens
Super User
9 years ago

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