a circular dependency was detected

[Piinherio]

Hello, 

I am trying to measure the stock level of certian items for a project. 

the table below shows the material number, SKU Qty (the quantity of final product to be produced), Qty means the quantity I need of this material to make one product for example material number 89 I need one item to make 1 product for material 99 I need two items of this material to make one product, stock is already there. 

I calculated Total Project Item = CALCULATE(SUMX(List1,List1[SKU Qty] * List1[Qty ])) in a column Not a measure. 

now I am trying to make a column for the status by  Status = IF(List1[Stock] < List1[Total Project Item], "Low", "ok")

but it shows an error " a circular dependency was detected: List1[total project item], list1[status], List1 [Total project item]

https://drive.google.com/file/d/1OUbNQB1jUcbSmqL5jKY1ATWnKUpcP1Ok/view?usp=sharing    Power Bi file

is there anyway to solve this. 

thanks in advance 

[HotChilli]

I think we can reduce this column to :

Total Project Item = List1[SKU Qty] * List1[Qty ]

and the Status column should work OK now.

Give it a go and let me know.

[Ahmedx · Accepted solution]

Is this what you are looking for?