topic Re: Need help to fix the circular dependency with the recursion in DAX Commands and Tips

Need help to fix the circular dependency with the recursion

MiXiang — Mon, 25 Sep 2023 15:39:24 GMT

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

Re: Need help to fix the circular dependency with the recursion

some_bih — Mon, 25 Sep 2023 13:24:24 GMT

Hi MiXiang

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

Re: Need help to fix the circular dependency with the recursion

MiXiang — Mon, 25 Sep 2023 14:46:02 GMT

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

Re: Need help to fix the circular dependency with the recursion

some_bih — Mon, 25 Sep 2023 14:27:31 GMT

Hi MiXiang is this solution, if yes accept it.

Re: Need help to fix the circular dependency with the recursion

MiXiang — Mon, 25 Sep 2023 14:38:31 GMT

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