Forum Discussion

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago
Solved

Strange Circular Dependency issue

So I'm trying to account for the error in package size maintained by us, versus the resellers.    My expression: Selling price correction = VAR test = LOOKUPVALUE( 'ALL PRODUCTS'[Pieces/case] ,...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Icon for Community Support rankCommunity Support
7 years ago

HI, DouweMeer 

For this error, it must be that one of 'ALL PRODUCTS'[Pieces/case], 'EMEA - Standard_1'[Selling Price], 'EMEA - Standard_1'[List Price] or  'EMEA - Standard_1'[Adjusted Cost] is calculate column and it is calculated based on anther table.

So just adjust it in the formula.

If you still have the problem, please share a simple sample pbix file.

 

Best Regards,

Lin

 

DouweMeer's avatar
DouweMeer
Icon for Impactful Individual rankImpactful Individual
7 years ago

v-lili6-msft 

 

I understand your theory as I was looking for that as well. But those fields are not calculated. 

 

Before this case, I also had the same issue with another expression:

 

lookupvalue ( all products [piece/case] , all product [item] , 'emea...' [product] )

 

where it would hit me with a circular dependency. I can't imagine a way where you can be hit a circular dependency when using a lookupvalue on a newly created calculated column. 

 

I fixed the previous circular dependency by creating a dynamic table and using that dynamic table to do a:

 

sum ( dynamic table , value( dynamic table [piece price] ) 

 

To me, it tastes like a bug. Think I'm going to do the dynamic table trick again to fix this crap. 

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, DouweMeer 

    Could you please share a simple sample pbix file for us to have a test :smileyhappy:

     

    Best Regards,

    Lin

     

    • DouweMeer's avatar
      DouweMeer
      Icon for Impactful Individual rankImpactful Individual
      7 years ago

      v-lili6-msft 

       

      Actually, I didn't though I could reproduce it. That is what always happens when I have these strange cases. But I'm hit with the problem that I can't attach attachments to the forum and other apps that will let me do it, are disabled by my company. Any chance you can pm me that I can send you the file?

       

      Otherwise, I think I found the bugger. But I still don't know why. 

       

      When I try to enable the 'both' relationshipWhere the problem is and its expression