Thank you for cross-selling showcase it was very interesting, I tried to implement the same concept of the showcase but on the (orders scope), I created the following measures: Placed Orders, Orders With Both Products and Orders With Both Products
After Implementation, I have the following questions:
1-The results not displaying any amounts when selecting any Item from filter product, what is the error made in the Dax text?
2- To measure the degree of association between the products purchased (ordered) I created 3 measures called: Support, confidence and lift based on the following blog: https://caseywhorton.wordpress.com/2017/06/27/market-basket-analysis-using-microsoft-power-bi-association-rules-with-dax/comment-page-1/#comment-141
But also the calculation is not doing anything? why this happened ? and how could be solved if it is not correct?
Please check the Pbix file on this shared link: