Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Help avoiding a circular dependency in a measure

I am trying to figure out how to build these measures while avoiding a circular dependency. I cannot use a calculated column due to the nature of the report. The only table that exists in the dataset...
Circular dependency
DAX
  • AlexisOlson's avatar
    AlexisOlson
    4 years ago

    Subtracting 4% is the same as multiplying by 0.96 and adding 8% to that amount is the same as multiplying by 1.08.

     

    EndOfYear balance = StartOfYearBalance * 0.96 * 1.08 = StartOfYearBalance * 1.0368

     

    So, your real annual return is 3.68%.

     

    Try updating your measure to take out the 4% in this variable:

    VAR CompundInterestRateForInvestment =
    PRODUCTX ( YearsRateActive, 1 + 0.96 * [Annual Return Value] )
AlexisOlson's avatar
AlexisOlson
Super User
4 years ago

Subtracting 4% is the same as multiplying by 0.96 and adding 8% to that amount is the same as multiplying by 1.08.

 

EndOfYear balance = StartOfYearBalance * 0.96 * 1.08 = StartOfYearBalance * 1.0368

 

So, your real annual return is 3.68%.

 

Try updating your measure to take out the 4% in this variable:

VAR CompundInterestRateForInvestment =
    PRODUCTX ( YearsRateActive, 1 + 0.96 * [Annual Return Value] )
  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    AlexisOlson While this wasn't the exact solution I needed to implement to get it to work, this helped me think about it in a different way and got my on the right track. Thank you for the help!