Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
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 =
Go to Solution.
Solved already. I just used the quick measure in powerbi. It just worked! 🙂
View solution in original post
@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.
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.
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.