Forum Discussion

Piinherio's avatar
Piinherio
Frequent Visitor
3 years ago
Solved

a circular dependency was detected

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 

 

2 Replies

  • HotChilli's avatar
    HotChilli
    Icon for Community Champion rankCommunity Champion

    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.

  • Is this what you are looking for?