Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Cross-sell model

Hi, am trying to replicate a cross sell model in Power BI. For the sake of simplicity, lets assume there are two tables: Customer and SKU Master. The starting point is always the customer. So If i se...
Need Help
  • dax's avatar
    dax
    6 years ago

    Hi data_banshee, 

    You could refer to my sample to see whether it work or not. You could replace Search with Slicer and use below measeure

    Measure 2 =
VAR aa =
    IF (
        ISFILTERED ( Customer[Customer Name] ),
        SELECTEDVALUE ( Customer[SKU Number] ),
        BLANK ()
    )
RETURN
    IF ( aa IN VALUES ( SKU_Master[SKU Number] ), 1, 0 )

    Best Regards,
    Zoe Zhi

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

sturlaws's avatar
sturlaws
Resident Rockstar
6 years ago

Hi Anonymous 

 

are you familiar with daxpatterns.com?

 

They have pattern called Basket Analysis which I think you can use.

 

Cheers,
Sturla

If this post helps, then please consider Accepting it as the solution. Kudos are nice too.