Need help to fix the circular dependency with the recursion

[MiXiang]

 ND

 

  

Can anyone help me to build the dax formula which can avoid the circular dependency? This is quite difficult because it include the recursion. But I think it can be solved because my answer are correct until the sixth month.

NP_B = Obtained the data from the Excel

ND_B = Obtained the data from the Excel

NS_B = Obtained the data from the Excel

NP = Previous ND+PreviousNS

ND = ND_B * (NP_R/NP_B-1)

NS = (NP_R*％)/3

NP_R = NP_B + NP

Can help me to build the dax formula for NP, ND, NS, NP_R to avoid circular dependency? Thanks a lot!!!

The picture are what I did. I did for the temp table, columns and measure. The picture below just one part of that. Hope that can be simplify too.

 

• NP_R used by ND and NS. Previous ND and NS sum up will be the NP. Previous NP and NS  involve the recursion. This caused the circular dependency was detected in "Temp R 2": V2[NS]. I used "Temp NP 2"+NP_B. My month will from 1 to 12.

The pic (Pic with handwriting) above is the columns that I used to build the calculation. "Temp" and "R" in V and V2 are calculated by measures and the remaining are calculated by the new columns

[some_bih]

Hi @MiXiang 

Not on picture from your pbi, but in your text. Check yellow. Hope this help, kudos appreciated.

[MiXiang]

• 

   

  Yup. NP_R used by ND and NS. Previous ND and NS sum up will be the NP. Previous NP and NS  involve the recursion. This caused the circular dependency was detected in "Temp R 2": V2[NS]. I used "Temp NP 2"+NP_B. My month will from 1 to 12.

The pic above is the columns that I used to build the calculation. "Temp" and "R" in V and V2 are calculated by measures and the remaining are calculated by the new columns

[some_bih]

Hi @MiXiang is this solution, if yes accept it.

[MiXiang]

Hi. Maybe you can see my replies above again so that you can understand. I think I gave more detailed explanation