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
WTAS80486
Helper IV
Helper IV

Circular dependency

 

HI, I am getting circular dependecy error. these two columns are calculated columns in a calclated table created from measures

 

 

WTAS80486_1-1677163189463.png

 

5 REPLIES 5
tamerj1
Super User
Super User

@WTAS80486 
This should be a measure not a calculated column

Tech usage new is a measure

@WTAS80486 

Look for the error in one of the calculated columns used in the measure's formula. 

There are no errors in the calculated columns used in this measure, they populated correct data in the calcuted table, but when i want to divide the sum of both calculated columns in tech usage measure, this error comes

amitchandak
Super User
Super User

@WTAS80486 ,while above should work, it need to be measure

 

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

 

You can check

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

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.