Circular dependency between two calculated columns that uses "UseRelationship".

Question

So in my model i have my order tabel,where i have an EmployeeID in colunms like&nbsp;PickedByShippedByControlledBy etc.&nbsp;I then have an employee table with information like the ID, name etc. that i have related on the employeeid to each and every column where it could be relevant throuh inactive relationships.&nbsp;&nbsp;&nbsp;When i try to create a column on the orders tabel that includes the name from the related table I can only get it to work on 1 column, the rest i get&nbsp;&nbsp;Essentially i created the "ShipmentBy" measure first and that one totally works. When i try to make new calculated columns I get this circular dependency error.&nbsp;Here is the shipment by column that works.&nbsp;ShipmentBy = CONVERT(Orders[ShipmentStartBy],STRING)&amp;" ("&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( 'MappingEmployeeID'[Name] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Orders',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP ( MappingEmployeeID[userid], 'Orders'[ShipmentStartBy] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS ( 'MappingEmployeeID' )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;") / "&amp;CONVERT(Orders[ShipmentCompletedBy],STRING)&amp;" ("&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( 'MappingEmployeeID'[Name] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Orders',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP ( MappingEmployeeID[userid], 'Orders'[ShipmentCompletedBy] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS ( 'MappingEmployeeID' )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&amp;")"&nbsp;&nbsp;Here is the picked column that does not work.&nbsp;PickedBy = CONVERT(Orders[OrderPickedStartBy],STRING)&amp;" ("&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( 'MappingEmployeeID'[Name] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Orders',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP ( MappingEmployeeID[userid], 'Orders'[OrderPickedStartBy] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS ( 'MappingEmployeeID' )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &amp;") / "&amp;CONVERT(Orders[OrderPickedCompletedBy],STRING)&amp;" ("&amp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SELECTEDVALUE ( 'MappingEmployeeID'[Name] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; CALCULATETABLE (&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 'Orders',&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; USERELATIONSHIP ( MappingEmployeeID[userid], 'Orders'[OrderPickedCompletedBy] ),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; REMOVEFILTERS ( 'MappingEmployeeID' )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; )&amp;")"&nbsp;&nbsp;Is it only possible to have 1 calculatetable and userelationship?

v-luwang-msft · Answer

Hi&nbsp;AlexaderMilland&nbsp;，
&nbsp;This error by creating calculated colum?,Why not try with measure?&nbsp;
&nbsp;
If you do have the error with creating a calculated colum, you could have a reference of this similar&nbsp;thread&nbsp;which has been solved.
&nbsp;
If you still need help, please share a dummy pbix file which can reproduce the scenario, so that we can help further investigate on it?&nbsp;You can upload it to public link. Do mask sensitive data before uploading.)
&nbsp;
&nbsp;
&nbsp;
Best Regards
Lucien

alexadermilland · Answer

Couldn't see a solution in the posted example. I've attached a link to a google drive containing a sample data.
Basically on the order table i want the Partner Name columns on each version. I can only get 1 of the 3 calculated columns to work (the first one)

.https://drive.google.com/file/d/1DA0AVhokYtpDas-UJrZUQGC9baySSa4B/view?usp=sharing

Forum Discussion

Circular dependency between two calculated columns that uses "UseRelationship".

2 Replies

Related content

Circular dependency

Remove circular dependency from calculated column

Circular dependency calculated column

Dax query dependency

dependent slicers

Forum Discussion

Circular dependency between two calculated columns that uses &quot;UseRelationship&quot;.

Circular dependency

Remove circular dependency from calculated column

Circular dependency calculated column

Dax query dependency

dependent slicers

Circular dependency between two calculated columns that uses "UseRelationship".