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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

Reply
icdns
Post Patron
Post Patron

A circular dependency was detected HELP!

Hello, 

 

Would like to ask for your help. Im trying to get the total of two columns but when im creating a total column it shows an error of: 

 

Total ColumnC_Contractor_Assigned_FIELD + C_Contractor_Assigned_MANUAL

Error: A circular dependency was detected: ED[C_Contractor_Assigned_FIELD], ED[C_Contractor_Assigned_Total], ED[C_Contractor_Assigned_FIELD].

 

Here are my two columns to be added:

Im trying to add column A = 

C_Contractor_Assigned_FIELD = CALCULATE(DISTINCTCOUNT(ED[ID]),ED[IN_FIELD] = "YES"))  
and column B = C_Contractor_Assigned_MANUAL = CALCULATE(DISTINCTCOUNT(ED[ID]),FILTER(ED,ED[VENDOR_ASSIGNED] = "YES" && ED[IN_FIELD] = "NO"))
 
Thank you!
 
 
1 ACCEPTED SOLUTION

Hi Everyone!

 

Solved already. I just used the quick measure in powerbi. It just worked! 🙂 

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@icdns , I saw equal to in formula. I am not sure is it typo here. it is like that in formula

 

these should be like

column A = C_Contractor_Assigned_FIELD - CALCULATE(DISTINCTCOUNT(ED[ID]),ED[IN_FIELD] = "YES"))

column B = C_Contractor_Assigned_MANUAL - CALCULATE(DISTINCTCOUNT(ED[ID]),FILTER(ED,ED[VENDOR_ASSIGNED] = "YES" && ED[IN_FIELD] = "NO"))

 

These seem fine. Can you share sample pbix after removing sensitive data.

 

refer :

column A = C_Contractor_Assigned_FIELD - CALCULATE(DISTINCTCOUNT(ED[ID]),ED[IN_FIELD] = "YES"))

column B = C_Contractor_Assigned_MANUAL - CALCULATE(DISTINCTCOUNT(ED[ID]),FILTER(ED,ED[VENDOR_ASSIGNED] = "YES" && ED[IN_FIELD] = "NO"))

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hello @ 

 

Sorry for the confusion but it's:

 

 C_Contractor_Assigned_FIELD = CALCULATE(DISTINCTCOUNT(ED[ID]),ED[IN_FIELD] = "YES"))

 C_Contractor_Assigned_MANUAL = CALCULATE(DISTINCTCOUNT(ED[ID]),FILTER(ED,ED[VENDOR_ASSIGNED] = "YES" && ED[IN_FIELD] = "NO"))

 

TOTAL = C_Contractor_Assigned_FIELD  + C_Contractor_Assigned_MANUAL  

 

But when i tried making the total column it shows an circular dependency error. 

Hi Everyone!

 

Solved already. I just used the quick measure in powerbi. It just worked! 🙂 

Helpful resources

Announcements
PBIApril_Carousel

Power BI Monthly Update - April 2025

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

Notebook Gallery Carousel1

NEW! Community Notebooks Gallery

Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.

April2025 Carousel

Fabric Community Update - April 2025

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

Top Solution Authors