Forum Discussion

Bryanna's avatar
Bryanna
Helper II
3 years ago

Cross-Selling Matrix

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

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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