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,

 

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.