Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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! 🙂
User | Count |
---|---|
84 | |
79 | |
64 | |
62 | |
51 |
User | Count |
---|---|
120 | |
99 | |
91 | |
83 | |
65 |