Error: Ring dependency detected for second calculated column

[qwertzuiop]

Hello dear Power BI-Community

Following Problem.

Le'ts assume following table

Let's say we own 4 stores in different cities.

We have data on their "result sales" and "target sales" for the year.

Let's assume we would like to adjust the "result sale" and the "target sale" about minus amounts.

For "result sale":
There are also minus amounts in other stores, but for simplicity's sake we'll just assume London.

For "target sale"

More information, because I think the problem lies in the measure's itself

Any ideas how to solve the error?
Thank you so much for your support.

Cheers
qwertzuiop

[v-eqin-msft · Accepted solution]

Hi @qwertzuiop ,

If you want to create two adjusted columns for both Result and Target, please try:

Adjusted_Result = IF([Result / Target]="Result", CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Store]),'Table'[Result / Target]="Result")-200,0)

Adjusted_Target = IF([Result / Target]="Target", CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Store]),'Table'[Result / Target]="Target")-100,0)

Or just in a single column:

Adjusted = SWITCH([Result / Target],"Result",CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Store]),'Table'[Result / Target]="Result")-200,"Target",CALCULATE(SUM('Table'[Sales]),ALLEXCEPT('Table','Table'[Store]),'Table'[Result / Target]="Target")-100,0)

 Output:

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

[amitchandak]

@qwertzuiop , You can not use measure in a calculated column

[qwertzuiop]

Thank you for your answer @amitchandak 

You helped but what is the alternative solution?