Cross Selling Matrix_Customer potencial

Hello everyone,

i have the question about cross selling matrix.

I have build the model from EDNA and it works great. :smiley:

But i would like to get the information automatically about the customer, basically what are the products that Customers can also have.

So i have build 100% the same model like in EDNA.

My goal is to get automatically the products for customer, that they do not have yet, to provide Customer Potencial. :slight_smile:
I have marked the graphs where I think such information would be useful.

Thanks a lot!
Best
Marija

Hello @mferry Marija Strobel. To help the forum members further analyze your current state and visualize your issue, could you please provide as many as you can of:

• Your work-in-progress PBIX file, using sanitized data if necessary
here’s [/u/brianj]@BrianJ’s YouTube video on how to anonymize data in a Power BI file: https://www.youtube.com/watch?v=VmWD7Ayw_NI
• Your dataset as an Excel file (again, sanitized if necessary)
• A detailed mock-up (marked-up screenshot of the visual in question or Excel file) showing your desired outcome.
• What is the EnterpriseDNA course/content referred to (provide URL)
• What is the video (provide URL)

Also, if you provide DAX or Power Query code in your post, please format it using the built-in formatting.

formatupload

Hello,

below i m sending the link for you: (506) Cross Selling Matrix Deep Dive - Power BI & DAX Tutorial - YouTube

That is a short version of 1h learning video, that i can not find any more here.

Unfortunatily i cannot understand the red pointed graph. Maybe is some mistake here.

Enterprise-DNA-Learning-Summit-Nov-2018-Resources-Pack.zip (5.2 MB)

I uploaded actually the version of yours here.
Hope you can explain to me the graph here and hope also that you understand my issue. :slight_smile:

Thanks a lot!!!
Regards,
Marija

Hi @mferry

If you open the power bi file and click on the graph, and look on the right hand side of the under the Cross Selling folder.open up the folder and go to Potential cross… formula and click on that. formula will appear in the formula bar where you can compare his formula and your formula to it. (look for the green check marks which indicates the formula used in the graph.

i hope this helps,
Keith

Thanks a lot, i had look at model from another perspective so now i understand all graphs. I didnt understand the concept right away. I thought i could clear see what are the customers that can have another products also. In this model i get also this information but not directly. Thanks All the best. Marija