Error : "A circular dependency was detected".

[Anonymous]

Hello Everyone,

I have a column in my table for "Country". To sort the countries in a specific way, i created another column by using below formula:

Country_Sort = 

                        SWITCH(TRUE(),

                         Table - Country] = "Canada",1 ,'Table' - [Country] = "USA",2, 'Table'- [Country] = "UK",3,'Table' - [Country] =                                 "Germany",4, 'Table' - [Country] = "AU",5,'Table' - [Country] = "NZ",6)

BUT  when i try to sort "Country" column in my table by using "Sort by column" option, i am getting below error:

Error : "A circular dependency was detected".

Need help to resolve above issue!!

Thanks !!

[VijayP]

@Anonymous 

When you create a Calculated column in the Report View you will get this error because the column which is created based a Column Cannot Sort the Same column because is Dependent on that Column (with a Formula).

Create a Custom column in Power Query Editor ,with the same logic and use that column for sorting . you will be successful

I am sure this will be a solution for  you and if so kindly share your Kudos and mark this as solution.

Regards

Vijay Perepa

[amitchandak · Accepted solution]

@Anonymous ,

Create a new column

Country 1= 'Table' - [Country] 

then

Country_Sort = 

                        SWITCH(TRUE(),

                         Table - Country] = "Canada",1 ,'Table' - [Country] = "USA",2, 'Table'- [Country] = "UK",3,'Table' - [Country] =                                 "Germany",4, 'Table' - [Country] = "AU",5,'Table' - [Country] = "NZ",6)

Sort Country1 on Country_sort and use country1