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,

 

Did you create the relationship between the result table and original table?

 

Regards,

Xiaoxin Sheng

sebastian_ebg's avatar
sebastian_ebg
Helper I
9 years ago

I can link it to the Mailing table, but not to the Customer table because it creates a circular dependancy.

 

I don't think that would be the issue though, as the measure obeys the filtering when applied as a card, but when used within another measure/table, it ignores filtering. Reading up on it a bit, it may be something to do with cross-directional filtering, but I'm definitely out of my depth there.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi sebastian_ebg,

     

    You can try to use values function to enable the slicer affect:

     

    Conversion Value = CALCULATE(SUM(LineItems[Value]), CustomerDetails[MailOpens] > 0, Attribution[DirectAttribution] = TRUE(), Values(ProductDetails[ProductType]))

     

    Regards,

    Xiaoxin Sheng

  • sebastian_ebg's avatar
    sebastian_ebg
    Helper I
    9 years ago

    Unfortunately that doesn't have any effect. I believe it's because of the context of the calculation. I might need to leave this for a while and re-visit it with a fresh look.