Forum Discussion

Dimi123's avatar
Dimi123
Frequent Visitor
7 years ago

Filter Table based on another Fact table

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 a...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

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's avatar
    Dimi123
    Frequent Visitor
    7 years ago

    Hi,

     

    You can find a sample report here: sample