Forum Discussion

KK111's avatar
KK111
Frequent Visitor
4 years ago
Solved

Ways to avoid circular dependency

Hello! I am trying to create a calculated column by dividing one column from table 1 by another column from table 2. I use the following:    =sumx(naturaljoin(table1,table2),column 1/ column2)   ...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    4 years ago

    Hi KK111 ,

     

    You can try to use LOOKUPVALUE function to create a calculated column in Table 1, then use SUMX function to calculate.

     

    Column 2 = LOOKUPVALUE(Table2[Sales],Table2[Product],Table1[Product])
Column 3 = SUMX(Table1,Table1[Column 2]/Table1[Quantities])

     

     


    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi KK111 ,

 

You can try to use LOOKUPVALUE function to create a calculated column in Table 1, then use SUMX function to calculate.

 

Column 2 = LOOKUPVALUE(Table2[Sales],Table2[Product],Table1[Product])
Column 3 = SUMX(Table1,Table1[Column 2]/Table1[Quantities])

 

 


Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.