Forum Discussion

DouweMeer's avatar
DouweMeer
Impactful 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
DouweMeer's avatar
DouweMeer
Impactful 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
Community 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
    Impactful 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