Forum Discussion

chua129's avatar
chua129
Helper I
8 years ago

Needed Help in circular dependency!!!

Hi Guys!

 

I need some help in circular dependency! I have a column that relies on a calculated column that is looked up from another table.  Tried to understand the articles that is posted earlier but i cant seem to! 

 

Thanks! 

Need Help

4 Replies

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    8 years ago

    Hi,

     

    Share some data, describe your question and show the expected result.

    • chua129's avatar
      chua129
      Helper I
      8 years ago

      Hi,

       

      Sorry, couldnt show the actual data as I have signed an agreement not to disclose. But here is a sample to what I am facing.

       

      I have 3 tables, lets call it A,B and C

       

      Table A has a column called Faculty and its specific ID

      so eg. SCS - U113 and so on.

       

      Table B has a column with the ID. (eg U113)

      I have a calculated column that obtains the faculty from Table A using a LOOKUPVALUE(Faculty(Table A), ID(table A), ID(table B)

       

      Table C has a column with a grouping and faculty. For example,

      Faculty SCS, ACS, OCS belongs to a group call Command.

       

      I need to obtain the grouping in Table B based on the calculated column from Table A but it is showing me the circular dependency error. This statement was used...

       

      group = IF('Data'[Faculty]="PCS","NO",IF(OR('Data'[Faculty]="OCS",'Data'[Faculty]="SCS"),CALCULATE(FIRSTNONBLANK('Group'[group],1),FILTER('Group','Group'[ID]='Data'[ID])),IF('Data'[Faculty]="VCS",CALCULATE(FIRSTNONBLANK('Group'[group],1),FILTER('Group',' Group'[Cycle key]='Data'[Cycle Key]),ALLEXCEPT(Data,Data[Team])))))

       

      Thanks !

      • Ashish_Mathur's avatar
        Ashish_Mathur
        Super User
        8 years ago

        Hi,

         

        You can share dummy data (in a form that ca be copied in MS Excel).