Cross-Selling Matrix

[Bryanna]

Hi,

I am trying to compare how often items are bought together. I've watched a ton of videos but it doesnt seem to be playing out as easily for me. As an example my table has a Transaction ID Number which signifies what products were bought on an order, along with the Products that were associated on that order. 

How can i update the query example below from this website Cross Selling Matrix In Power BI Using DAX | Enterprise DNA , to work with my data? Any help is appreciated

[Anonymous]

HI @Bryanna,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

BTW, I'd like to suggest you contact the report author to ask for template file, then you further analysis these contents and replace to your data source and testing with these visual and formulas.

Regards,

Xiaoxin Sheng