calculated column to sort ...circular dependency error

[Raj007]

Hi All, looked at few links on circular dependency error but still not following .. i have this scenario where i have to this using DAX columns only...not in Power Query

1).I am trying to create a column that includes the buckets

2).Create another column and sort the column created in Step #1 to sort ...but iam getting circular dependency error

Step#1

NoEvidence=

SWITCH(TRUE(),

(

JIRA#=BLANK() && DaysToExp>=0  && DaysToExp <=3  && TrackerStatus <> "Completed" && Status <> "Inactive", "0-3",
JIRA#=BLANK() && DaysToExp>=4  && DaysToExp <=11 && TrackerStatus <> "Completed" && Status <> "Inactive", "4-11",
JIRA#=BLANK() && DaysToExp>=12  && DaysToExp <=30 && TrackerStatus <> "Completed" && Status <> "Inactive", "12-30",
JIRA#=BLANK() && DaysToExp>=31   && TrackerStatus <> "Completed" && Status <> "Inactive", ">=31",
"NotApplicable"  --Else part
)
Step#2

NoEvidenceSort=
IF(NoEvidence="0-3",1,

IF(NoEvidence="4-11",2, 

IF(NoEvidence="12-30",3, 
IF(NoEvidence=">=31",4, 

IF(NoEvidence="NotApplicable",5 

)))))
Step3
When I select NoEvidence column and click on sort by column and select the NoEvidenceSort - this is where i get  the no circular dependency error

any insights/helpful ideas are really appreciate

[v-yalanwu-msft]

Hi， @Raj007 ；

I think here you could use DaysToExp column as sort column. Or can you share a simple file and show the output you want ?

Looking forward to your reply!

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Raj007 , Create a new column

NoEvidence 1 =[NoEvidence]

Now mark NoEvidenceSort as the sort column for NoEvidence 1 and use NoEvidence 1 in visual

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

[Raj007]

Amit, i got the same error - 

[Raj007]

Thank you Amit, let me try this approach