Forum Discussion
Circular Dependency when adding custom columns
Hi All,
Basically, I get a circular dependency because I am creating a scoring system to put on a line graph. I am able to do what I want with a measure, but I can't get the measure into the line graph visualization that I need.
Calculated column 1 comes from different collected metrics, and creates a score based on those metrics.
Calculated column 2 takes calculated column 1 sum + adds to that.
Calculated column 3 takes calculated 2 sum + adds to that.
Lastly, Calculated column 4 takes calculated colum 3 sum and add to that.
The plan is to then unpivot calculated columns 1,2,3,4 into a type, so I can then put them on a line graph with the axis being columns 1-4.
Unfortunately, whenever I try to add calculated columns, even if I just do the calculated column 1 source formula and add it to calculated column 2, I get a circular dependency.
Is there any ideas to solve this?
Hi Anonymous ,
Sorry for the late reply, I think you can try using variables to avoid Circular Dependency.
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Anonymous Read this post to get your answer quickly.
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490Hi Anonymous ,
I'm a little confused by your description. Kindly share your sample data and expected result if you don't have any Confidential Information.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Joesh,
I do have some confidential info unfortunately, but I may be able to describe better and give examples.
I'm creating a scoring system that I want to put on a line graph, each point being a stage (4 stages/customer) so I cannot use measures as I can only do one measure on a line graph. However, measures do accurately calculate each stage. The main table that all the metrics link to (including this summary table) includes a customer identifier, so I'd be able to filter my report tailored to each customer.
Each stage adds the previous stage before. So, Stage one is calculated by this equation:
Stage 1 = CALCULATE(if ((SUM('questionnaire'[q1])) = 1,4,0))
+ Calculate(if ((SUM ('questionnaire'[q2])) = 1,3,0))+ Calculate (if ((SUM ('questionnaire'[q3])) = 1,2,0))+ Calculate (if ((SUM ('telemtry'[metric1])) > 4,3,0))+ Calculate(if ((SUM ('telemetry'[metric2]))> 4,5,0))+ Calculate (if ((SUM ('telemetry'[metric3])) > 50, 3,0))+ Calculate (if ((SUM ('telemetry'[metric4])) > 5,2,0))+ Calculate (IF ((SUM ('telemetry'[metric5])) > 100, 3,0))Stage 2 = = CALCULATE (('Line graph'[stage 1]) ## adding the stage1 to this score..+ Calculate (if (Calculate (COUNTROWS('billingdata'),'billingdata'[specificSKU] = "specificproduct") > 1,2,0))+ Calculate(if ((SUM ('telemetry'[metric6])) > 2,3,0))+ Calculate (if ((SUM ('telemetry'[metric7])) > 4,-3,0))+ Calculate (if ((SUM ('telemetry'[metric8])) > 3,5,0))+ Calculate(if ((SUM ('questionnaire'[q4])) = 1,5,0))+ Calculate (if ((SUM('questionnaire'[q5])) = 1, 5, 0))+ Calculate (if ((SUM('questionnaire'[q6])) =1, 5, 0)))When I try to add the second score in a calculated column, I get the circular dependency errorHi Anonymous ,
Sorry for the late reply, I think you can try using variables to avoid Circular Dependency.
Here is a demo, please try it:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
