Filter Table based on another Fact table

[Dimi123]

Hi,

I have a model with 2 fact tables: Sales en Advice, who are both related to Product, Customers and Date dimension.
I now want to calculate the sales revenue of the customer & product after an  advice of the same customer and product. For ex: customer A has an advice on 2019-02-01 of product X, so what is the sales revenue of product X for Customer A after 2019-02-01?

Thx!

[Anonymous]

I think you would need to create bridge table of Customer and Product and use that table as a fitler in your measure. Would you happen to be able to upload a sample data set?

[Dimi123]

Hi,

You can find a sample report here: sample