Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Custom field is giving circular dependency error.



I need help with doing aggregations in my power bi report. In the screenshot below, I am trying to do the multiplication of a custom field I have created agaisnt a field I have in my report. However i keep getting this circular dependency issue.


Can someone please suggest the best way to get around this? It essentially happens for every custom field I try to create.


Thanks in advance

Resident Rockstar
Resident Rockstar

Hi @TodGrindley,


Normally, when building complex DAX code or creating calculated tables, we may encounter the problem of circular dependency errors .


If it is convenient, could you share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading.)


Besides, Here is a similar thread, you could refer to.


For further, you could have a good look at avoid circular dependency errors.


Best Regards,


Community Support Team _ Cherry Gao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!


Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors