Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hello!
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.
Any help would be greatly appreciated, thank you!
(Original, no issues)
(New code, causes circular dependency error)
(Attempted Solution, all Table1 columns give a "Cannot Find Name" error)
(Original issue)
Solved: Re: Replace a value with data from a different tab... - Microsoft Fabric Community
Can you provide a screenshot of what your data model looks like and the tables you have? I think you just need to rework your model to avoid these confusing measures.
Here's the table layout:
Table Structure:
Table 1 (if blank) --> Table 2 --> Table 3 --> Table 4 (use this value)
Table 1 -> Table 2: Many to Many, Cross Filter Direction: Both
Table 2 -> Table 3: Many to One, Cross Filter Direction: Both
Table 3 -> Table 4: Many to One, Cross Filter Direction: Both
The data itself is imported from Dynamics 365 so I can't rework the model unfortunately.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
81 | |
79 | |
58 | |
35 | |
34 |
User | Count |
---|---|
99 | |
59 | |
56 | |
46 | |
40 |