Table relations

[Raul]

Hello and Happy new year!!

I have this data model in my Power BI Desktop file:

The dot line is a inactive relation between this tables because I can't relate them directly (it's show an error message that it would generate ambiguity between the tables Custormers and HistoricalInvoicesLines). How can I relate this tables? I need to know for a Record[CodRecord] which are the SUM(HistoricalInvoicesLines[Amount]) for this record.

Thank you!

[WolfBiber]

Or use this model approach:

[WolfBiber · Accepted solution]

Hey,

you should use

USERELATIONSHIP(<columnName1>,<columnName2>)  

It explicit uses a relationship for calculating a measure.

https://msdn.microsoft.com/en-us/library/hh230952.aspx

https://www.sqlbi.com/articles/userelationship-in-calculated-columns/

Greetings.

[Raul]

Great!!! Thank you very much, the USERELATIONSHIP function is the solution.

[vijay_kolisetty]

Hi

In this case you have check the data inside this entities or you can create one more entity by having distinct records and link it with Historical.

Regards,

V