Circular Dependency error while creating relationship between two table

[sagarsahoo_123]

Hi All,

Please help me to resolve circular dependency error while creating relationship between two tables.

I want to rearrange the below given value in that particular order.

But by default it is coming in the below order.

To acheive in the right order i created one more Table with this value by entering data and tried to create relationship with the main table. But it is throwing the error given below.

In the Above, VW_Nippon_Productivity is my main data table and ILP Effort Matrix table is created for sorting. I want to make relation between ILP Effort Matrix column of main table with "ILPEffortMatrix" column of ILP Effort Matrix table.

Any help on this would be highly appreciated.

Thanks,

Sagar

[amitchandak]

@sagarsahoo_123 , If you have created that table from this table try to use distinct on top of it.

Example

Distinct(All(Table[Col]))

Also, in the table shown above you can mark Sorting as a sort column

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c

[sagarsahoo_123]

Hello Amit,

Actually I created a simple table manually by using Enter Data option given image below.

Then tried to create relationship with main table.But not sure why i am facing circular dependancy error. Tried your given approach as well but it could not solve the problem.

Any thing which i am missing here!Please suggest.

Regards,

Sagar