Forum Discussion

jamuka's avatar
jamuka
Helper IV
6 years ago

Circular Dependency

Hello,

 

 

I tried to create a stock report, based on stock quantity and forecast amount on Store/Warehouse level.

Numbers should change based on selection, e.g product x could have an 1000 total forecast but in warehouse1 it can be 100 and I want other related columns changed with this selection.

 

I create a measure for Stock / Days amount and tried to create calculated columns for distribution of this amount based on several conditions. So I can slice my stock amount based on product availability levels (Stock Qty / Forecast Qty) e.g "Out of Stock", "15-30 Days" etc. and it will changes accordingly.

 

But I get an error message  says "A circular dependency was detected"

 

I found that root of the problem is calculated tables but I don't have any in my report. Also I assume if I use measures instead of calculated columns there will be no problem. But I don't know how to do it.

 

Also I get an different error I tried to count my products distribition therefore I want to use distinct count but again I get an error.

"The expression contains multiple columns, but only a single column can be used in a True/False expression that is used as a table filter expression."

 

attached you can see my file Stock Report 

 

 

kind regards

 

 

Need Help
Tips and Tricks

4 Replies

    • jamuka's avatar
      jamuka
      Helper IV
      6 years ago

      Hi v-diye-msft,

       

      I read it but all I understand from it is, that I can not use a measure in a calculated colum, but didn't understand how to avoid it.

      I'm trying to create a new table and will make my measure in it, then make my calculated columns in current table, maybe it will work.

       

      thanks

      • v-diye-msft's avatar
        v-diye-msft
        Community Support
        6 years ago

        Hi jamuka 

         

        If you'd like to avoid the Circular Dependency error, please :

         

        1. Use measure instead of a calculated column.

        2. If the calculated column is bound needed, please create it in power query using M code. 

        3. Create a NEW table that manages the relationship between them, that not all calculated column fetches the data in the same table.

         

        BTW, there no [Days] column in your sample that results in many formula errors.