Circular dependancy

[AGo]

I've got table A and table B linked with one-to-many relation (not every element in A is linked to one or more element in B).

I've got a measure that summarizes fields contained both in A and B.

In A there is "Product" field.

Table A has its date field and B has its date field, now I want to create a matrix with my measure as value, Products as rows and months in column. The problem is that date informations are on two different columns separated in A and B. I can't link A and B to a calendar table. What can I do?

[jthomson]

Data would certainly help here as well as what exactly you're trying to show - when you say you want months as column, which months?

[AGo]

All of the months of both of the date columns (table A and B).
I figured out one way: create a union of values of the two columns as new table linked to nothing. Then filter my CALCULATE measure with both DateInTableA and DateInTableB IN VALUES of date column the new calendar table. This works but it's a little too heavy and not very versatile. Better solutions?

[v-shex-msft]

Hi @AGo ,

Please share a pbix file with some sample data so that we can test on it. 
In addition, you can also take a look at following blog to know how to avoid this issue:

Avoiding circular dependency errors in DAX

Regards,

Xiaoxin Sheng