Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills 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! 🙂
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.