I’ve read all the similar topics regarding subjects about “Basket Analysis”, but cant find a solution to my question.
I have built a model that consider three key metrics when evaluating association rules. Those are Support, Confidence and Lift. All of it is built with the help of this article: https://finance-bi.com/power-bi-basket-analysis/
My model checks the association in the basket analysis in regarding to different Brands that was bought together. Everything works perfectly, but now I want to take it further and would like to add some Slicers to make some filters such as Date, Country and Shop for example.
The problem is that I can’t figure out a way to create a relationship between the two tables to filter e.g. Date.
Link to the model