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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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"))

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors