Forum Discussion
Table relations
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!
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.
4 Replies
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.
Great!!! Thank you very much, the USERELATIONSHIP function is the solution.
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
Or use this model approach:
