Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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 Column = C_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 =
Solved! Go to Solution.
Hi Everyone!
Solved already. I just used the quick measure in powerbi. It just worked! 🙂
@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 @ amitchandak
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! 🙂
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
105 | |
68 | |
48 | |
42 | |
41 |