CUSTOM SORT ORDER FOR SLICER - CIRCULAR DEPENDENCY ERROR

[amane]

Hello,

I have created a calculated column for the customer sort order of a particular column!

I have getting the below cicrcular dependency error! Please help : 

[v-yangliu-msft]

Hi  @amane  ,

Dax cannot build interdependence. If two objects depend on each other, they don’t know which one to calculate first. For example, if CC Express[cc_segment] depends on CCExpress[cc_segment_Order], and at the same time CCExpress[cc_segment_Order] depends on CC Express[cc_segment], then it is impossible to calculate CC Express[cc_segment] and CCExpress[cc_segment_Order].

This is about why circular dependencies are generated and how to avoid circular dependencies, hope it will help you:

https://www.sqlbi.com/articles/understanding-circular-dependencies/

https://www.sqlbi.com/articles/avoiding-circular-dependency-errors-in-dax/

https://community.powerbi.com/t5/Desktop/quot-A-circular-Dependency-was-detected-quot-error-while/td...

https://community.powerbi.com/t5/Desktop/Error-circular-dependency/m-p/38909

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k]

@amane how you are creating the column? Share DAX expression and also on which column you are using this as "Sort By"