circular dependency

[Alberto95]

hi, i've a problem with circular dependency. 

i need 2 different calculated colums. 

the first one it's a calculated colum with some if conditions (i did it without problems)

the second one is a column which contain the first calculated column in the formula. that's give me a circular error. 

IMPORTO_NETTO = if(VENDITE_ICG[COD_CLIENTE] = "266463IN"  && VENDITE_ICG[COD_PORTO] = "M" && VENDITE_ICG[COD_CANTIERE] = "372632" && VENDITE_ICG[VAL_TRASP] = 0, 3, calculate(SUM(VENDITE_ICG[VAL_TRASP])/SUM(VENDITE_ICG[QTA])))))))

VAL_TRASP_1 = CALCULATE(SUM(VENDITE_ICG[QTA])*SUM(VENDITE_ICG[IMPORTO_NETTO]),(ALLEXCEPT(VENDITE_ICG,VENDITE_ICG[IMPORTO_NETTO])))

the structure is easy, 2 tables: data table and vendite_icg (1-n relationship)

could someone help me? 

thanks

[v-zhangti]

Hi, @Alberto95 

After testing, the computed column detects circular dependencies. But measure doesn't.

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Alberto95 , can you share excat error

Try like

VAL_TRASP_1 = CALCULATE(SUM(VENDITE_ICG[QTA])*SUM(VENDITE_ICG[IMPORTO_NETTO]),filter(VENDITE_ICG,VENDITE_ICG[IMPORTO_NETTO] = earlier(VENDITE_ICG[IMPORTO_NETTO]) ))

refer: https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/