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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.