Forum Discussion

sebastian_ebg's avatar
sebastian_ebg
Helper I
9 years ago

Multi-table DAX Attribution Model

I'm trying to generate an attribution model for our company's emails based off a few different related tables. I'm fairly new to DAX, so I've been fumbling around a bit searching for examples of how ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi sebastian_ebg,

 

Can you share us a sample file to test? It is hard to know your table relationships from your screenshot.

 

Regards,

Xiaoxin Sheng

  • sebastian_ebg's avatar
    sebastian_ebg
    Helper I
    9 years ago

    Unfortunately it's very difficult for me to share a sample file as it contains sensitive data. I may spend a day anonymising and reducing the data so that I can share it because it still has me stumped.

     

    In the mean time, this is the relationships of the tables:

     

    LineItems[SKU]* - ProductDetails[SKU]1
LineItems[CustomerKey]* - CustomerDetails[CustomerKey]1
MailingDataFull[CustomerKey]* - CustomerDetails[CustomerKey]1

     

    Hopefully this helps. If not, I will work on anonymising the data.

  • sebastian_ebg's avatar
    sebastian_ebg
    Helper I
    9 years ago

    I've updated the post to clarify the problem and added an example with simplified data.

     

    I've also uploaded the example file here to hopefully get some help with it.

     

    Regards,

    Sebastian

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi sebastian_ebg,

       

      Based on research on your sample file, I can't get the cost of specify mailing item and mailiing key. There is no direct relationship between custom to item or item to price.

       

      Regards,

      Xiaoxin Sheng

      • sebastian_ebg's avatar
        sebastian_ebg
        Helper I
        9 years ago

        I'm not sure if I'm following. There definitely is a relationship between all those fields. The relationship flows as follows:

        MailingDataFull[CustomerKey] Many:1 CustomerDetails[CustomerKey]
CustomerDetails[CustomerKey] 1:Many LineItems[CustomerKey]
LineItems[SKU] Many:1 ProductDetails[SKU]

        The price is determined from the LineItems[Value] field. You're right in that there's no direct relationship between MailingDataFull and LineItems, however there is a unique relationship between the CustomerKeys in MailingDataFull and the CustomerKeys in LineItems.