Relationship is not working

[Anonymous]

Hello all,

I am working on a report to show all sales data.

Our database works with 3 different date types for the sales proces (create date, estimate close date and actual close date). They are all in the same table. Because of this I work with inactive relationships between these dates in the database and my date table.

To calculate the amount won I made a measure which works perfect.

But when I add the name of the company the result is all goes all wrong. I get a list of all companies and opportunities which don't relate. 

When I make the relationship between my datatable and the actual close date active manually, and use all the filters in reports it works fine. But in that case other visuals wont work because of the active relationship

Did I made a mistake with the relationships?

Thanks in advance

[jcalheir]

Hi

I dont know the actual logic of your model, but can you connect the oportunity table with the ancestor table by an ID? Insted of connecting by the 3 dates?

Also, your company table has a the wrong cardinality (Many to 1 to the facts table), it should be 1 to many if you want to follow the star schema model.

Kind regards,
José
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 🙂