Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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!
Solved! Go to 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.
Or use this model approach:
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
User | Count |
---|---|
107 | |
88 | |
81 | |
76 | |
71 |
User | Count |
---|---|
112 | |
104 | |
96 | |
74 | |
66 |