Forum Discussion

andrea_chiappo's avatar
andrea_chiappo
Helper III
6 years ago

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...
Need Help
  • andrea_chiappo's avatar
    andrea_chiappo
    Helper III
    6 years ago

    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