Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

Circular dependency

Hello, i was trying to find the delta variance of 2 columns minutes from table A and minutes from table B.

i used this formula in column inside table B :

Delta =CALCULATE(SUM(TableA[Minutes])-SUM(TableB[Minutes]))
then i needed to find the percentage in Table B by creating a column which is percentage =  delta/ Table A[minutes]
but i get error <pi>A circular dependency was detected: TableB[Delta], TableB[Column], TableB[Delta].</pi>
1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi @Anonymous,

 

To resolve circular dependency issues, you could consider these solutions.

1 Change Calculated column to Measure as amitchandak said

2 Modify your Calculated column formula with some filters functions like REMOVEFILTERS

3 Make some changes to the relationships in your model

 

Please take a look at this blog related to how to fix issue of Circular Dependency: Circular Dependency between Calculated Columns in ... - Microsoft Power BI Community. Hope it helps you.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

 

Best Regards,

Community Support Team _ Caiyun

View solution in original post

2 REPLIES 2
v-cazheng-msft
Community Support
Community Support

Hi @Anonymous,

 

To resolve circular dependency issues, you could consider these solutions.

1 Change Calculated column to Measure as amitchandak said

2 Modify your Calculated column formula with some filters functions like REMOVEFILTERS

3 Make some changes to the relationships in your model

 

Please take a look at this blog related to how to fix issue of Circular Dependency: Circular Dependency between Calculated Columns in ... - Microsoft Power BI Community. Hope it helps you.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let me know. Thanks a lot!

 

Best Regards,

Community Support Team _ Caiyun

amitchandak
Super User
Super User

@Anonymous , You need to create another measure

Delta % = divide( [Delta], SUM(TableA[Minutes]))

 

you should not use measure in a column

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.