Filter Table based on another Fact table

Question

Hi,&nbsp;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 &amp; product after an&nbsp; 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?&nbsp;Thx!

anonymous · Answer

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 · Answer

Hi,&nbsp;You can find a sample report here:&nbsp;sample&nbsp;&nbsp;

Forum Discussion

Filter Table based on another Fact table

2 Replies

Related content

Filtered table

FILTER TABLE BASED ON ANOTHER TABLE

Filter table using another table result

Conditionally filtering rows from a table with another table

Filtering Dates from another table