How to solve circular dependency

Question

I'am trying to calculte my result + another measure but it keeps generatin circular resultsCircular Dependency: Measure: 'Medidas'[Result], Measure: 'Medidas'[Total Variable], Measure: 'Medidas'[Value to rec Step I], Measure: 'Medidas'[Result Aloc Step I], Measure: 'Medidas'[C/C], Measure: 'Medidas'[Result].&nbsp;Result = VAR vPreviousMonth = CALCULATE([Total Variável], PREVIOUSMONTH(dim_Calendario[Data]))VAR vCurrentMonth = [@Result]RETURN&nbsp; &nbsp; vPreviousMonth + vCurrentMonth&nbsp;C/C =VAR CurrentDate = MAX('dim_Calendario'[Data])RETURN&nbsp; &nbsp; SUMX(&nbsp; &nbsp; &nbsp; &nbsp; FILTER(&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ALL('dim_Calendario'),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'dim_Calendario'[Data] &lt;= CurrentDate&nbsp; &nbsp; &nbsp; &nbsp; ),&nbsp; &nbsp; &nbsp; &nbsp; [Result]&nbsp; &nbsp; )Result Aloc Step I = CALCULATE(&nbsp; &nbsp; IF(&nbsp; &nbsp; &nbsp; &nbsp; [C/C] &lt; 0, 0,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF([C/C] &gt; 0, &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; IF([C/C] &lt; [Target, [C/C], [Target])&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; ))&nbsp;Value to rec Step I = [Result Aloc Step I] * [% Step I]Total Variable = [Value to rec Step I] + [Value to rec Step II]

pborah · Answer

Anonymous&nbsp;, What action triggers that error?

anonymous · Answer

Hello&nbsp;pborah&nbsp;when I try to calculateC/C based on the [Result]:&nbsp;Result =VAR&nbsp;vPreviousMonth =&nbsp;CALCULATE([Total Variável],&nbsp;PREVIOUSMONTH(dim_Calendario[Data]))VAR&nbsp;vCurrentMonth = [@Result]RETURN&nbsp; &nbsp; vPreviousMonth + vCurrentMonth

pborah · Answer

Thanks&nbsp;Anonymous&nbsp;can you tell me the order of your measure calculations? As in which one you are calculating first, second, third,......, last?

anonymous · Answer

Hello&nbsp;pborah&nbsp;Ok, see below the order. All the measures that I am using is these ones above. Please let me know if you need them again1. Calculating the result:2. Calculating C/C3. Calculating&nbsp;Value to rec Step I4. Calculating&nbsp;Value to rec Step II5. Calculating Total Variable = [Value to rec Step I] + [Value to rec Step II]6. Adding Total Variable into Result = [Result] + [Total Variable]In the moment I add Total Variable into Result, the circular dependency apperarsSe the measure below:Resultado Realizado =VAR vResult&nbsp;= [@Result]RETURN&nbsp; &nbsp; vResult&nbsp;+ [Total Variable]

ashish_mathur · Answer

Hi,
Share some data to work with, explain the question in simple English and show the expected result.

Forum Discussion

How to solve circular dependency

7 Replies

Related content

Circular dependency

Circular Dependency

DAX Help - Circular Dependency

Circular Dependency Error

A Circular Dependency was detected