Forum Discussion
Circular Dependency error
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])
Hi Anonymous,
You have a circular dependency because of the table context and this can be influenced by the relationships within your model, not only the row context.
How is your model setup do you have any relationship between the tables you are making the lookupvalues?
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
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.
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])