Can't Solve Circular Dependency, CALCULATE Can't See Values
I previously had a problem of replacing a value from a table three dependencies deep. Below is the link and the solution I found.
I recently got another request for the same issue but to pull a different value. Figured it wasn't a problem and just made a new column with the same code, replacing "Table4[Table 4 "account"]" with "Table4[Table 4 "new_request"]" (code below).
This caused the circular dependency error. From my research, the solution is to add CALCULATE with a REMOVEFILTERS filter. However, the code for some reason gives a "Cannot Find Name" error for all column names for table1, which is where the new column sits (third example below).
Moving the logic to a different table isn't a viable solution, and isn't sustainable anyway if these requests keep coming in.