Forum Discussion

Raj007's avatar
Raj007
Helper III
4 years ago

calculated column to sort ...circular dependency error

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

Need Help

4 Replies

    • Raj007's avatar
      Raj007
      Helper III
      4 years ago

      Thank you Amit, let me try this approach

  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    Community Support
    4 years ago

    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.