Forum Discussion
Two identically calculated columns, one circular dependency error message
I have (among other) the following two tables: DimGroups[groupID] <-> DimGroupsUsers[groupID] where the arrow indicates that there's a two-way relationship linking the tables via the dimension [gr...
there is already a many-to-one relationship
but the following
fatherGroupDescription = LOOKUPVALUE(DimGroups[description], DimGroups[groupID], RELATED(DimGroupsUsers[groupID]))
returns an error
Yet, I don't understand why creating a column using LOOKUPVALUE the first time works, while the second it doesn't