Error : "A circular dependency was detected".

Question

Hello Everyone,&nbsp;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:&nbsp;Country_Sort =&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(TRUE(),&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table - Country] = "Canada",1 ,'Table' - [Country] = "USA",2, 'Table'- [Country] = "UK",3,'Table' - [Country] =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Germany",4, 'Table' - [Country] = "AU",5,'Table' - [Country] = "NZ",6)&nbsp;BUT&nbsp; 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".&nbsp;Need help to resolve above issue!!&nbsp;Thanks !!

amitchandak · Accepted Answer

Anonymous ,
&nbsp;
Create a new column
Country 1= 'Table' - [Country]&nbsp;
&nbsp;
then
Country_Sort =&nbsp;

&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; SWITCH(TRUE(),
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Table - Country] = "Canada",1 ,'Table' - [Country] = "USA",2, 'Table'- [Country] = "UK",3,'Table' - [Country] =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;"Germany",4, 'Table' - [Country] = "AU",5,'Table' - [Country] = "NZ",6)
&nbsp;
Sort Country1 on Country_sort and use country1

&nbsp;

Forum Discussion

Error : "A circular dependency was detected".

2 Replies

Related content

Circular dependency

Circular Dependency

DAX Help - Circular Dependency

Circular Dependency Error

"A circular Dependency was detected" error while creating a calculated column