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.

     

dax's avatar
dax
Community Support
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.