Dates Table Relationship

[Anonymous]

I have what should be a simple relationship I am trying to make between 2 data sets. 

One set contains the sales person and all of their invoices by date, the other set contains each sales person with their monthly quota. I am trying to get the dates in each data set to have a relationship but can't not figure out what I'm doing incorrectly. I'm simply trying to see each sales persons monthly quota and monthly invoices in one visualization. 

When I built a relationship between data sets for the sales people, which seems to work fine, but when I go to create the relationship between dates it does not let me make the relationship active 

[Anonymous]

What this message is expressing is that in the context of your entire data model, adding a relationship specifically between those 2 tables can't be done because the relationship already exists inside the data model, just more indirectly.

For example, if you had 3 tables: A, B and C.  If A -> B and B -> C is what you have right now.  You are trying to link A -> C, but because you can already get to the C through B, it isn't letting to link it again.

There are examples where you could do A -> B, A ->C and B -> C, but this depends on the type of relationships used.

I would urge you to review your entire data model, the flow of filters and the 1-1, 1-* type relationships.  You might that that you already have the relationship you need, or perhaps there is an issue in your model that might give you data integrity problems.