Forum Discussion

ConstMoss's avatar
ConstMoss
Helper I
9 years ago

Power BI model

 Hello all – I have the following tables.

 

  1. Sale
  2. Customer
  3. Channel
  4. Marketing Campaign

 

  1. Customer is related to Sales on CustomerID.
  2. Channel is the means by which a customer get to the Sales (friend, search, etc.). Customer is related to Chanel on CustomerID. Each customer can come through multiple channels until they purchase something.
  3. Marketing Campaign is similar to Channel.  Customer is related to Marketing Campaign on CustomerID.

 

We’d like to track sales by channel and Marketing Campaign but unable to get the data model to work – it doesn’t let us setup bidirectional filter on some joins and when it does, it won’t let us join some tables. Any idea how to setup the data model in this scenario?

Thanks in advance!

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi ConstMoss

     

    Can you share the data model and sample data.

     

    Cheers

     

    CheenuSing

      • v-huizhn-msft's avatar
        v-huizhn-msft
        Microsoft Employee
        9 years ago

        Hi ConstMoss,

         

        I download the file successfuly, do you want to track all channels and canpains for each customer? What do the result format look like? Could you please share a picture or table to list the expected result? Thanks a lot.

         

        Best Regards,
        Angelia