Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 gr...
Need Help
Tips and Tricks
v-joesh-msft's avatar
v-joesh-msft
Solution Sage
6 years ago

Hi 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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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 error