Forum Discussion
Circular Dependency error
Hello, I am attempting to write a DAX expression that references two calculated columns and one other column from the source data. The error message I receive is as follows: A circular depe...
Hi Anonymous ,
Taking into account that you have relationships between the tables you can change the LOOKUPVALUE by a RELATED making the circular dependency to be eliminated:
Status Country Name = RELATED('Country Code Mapping'[Country Name])
Thanks for the response. Regarding the lookupvalues here is the relationship between tables:
Where 'Sustainability Mapping' has unique rows based on unique SAP codes. If you still need a sample of the data set please let me know, I will have to create a mockup as the actual data source is business sensitive.
If you can send the mockup by private message that would be great.