Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |