USERELATIONSHIP - Three tables relations

[smpascual]

Dear all,
I'm trying to develop a Measure to obtain Product Cost by Month but I'm getting wrong results.

My datamodel is as following:
Calendar -- Invoice -- InvoiceLines

Which have realtionships below:

1.- Calendar[Date] -- Invoice[Date] --> Active
2.- Calendar[Date] -- Invoice[Cost Date] --> Inactive
3.- Invoice[id] -- InvoiceLines[invoice_id] --> Active

My measure is as following

CALCULATE (
[Euros - Purchase by Product];
USERELATIONSHIP ( Invoice[Cost Date]; 'Calendar'[Date] )
)

[Euros - Purchase by Product] = SUM(InvoiceLines[Amount])

Thanks for your help in advance

[masterelaichi]

Do you have a sample data? I am not sure what the last line of code, [Euros - Purchase by Product] = SUM(InvoiceLines[Amount]), is being used for

[RamanaV]

Looks like you 2 transaction(fact/data) tables - Invoice and InvoiceLines
If that's the case you cannot have a relationship between Invoice and InvoiceLines