Forum Discussion

elaj's avatar
elaj
Icon for Helper IV rankHelper IV
6 years ago

DAX to create a sort column without having ring dependency problem

Hi guys,   i try to sort a column by a DAX calculated column wich references the column wich i want to sort. therefore i get a ring dependency problem.   My workaround would be to copy the colum...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi elaj,

I think this dependency issue is caused by using the raw field in other fields calculated and invoke this calculated field on raw field operations. (if you keep this scenario, I don't think you can prevent dependency issue appears)

Perhaps you can try to create a new table to extract these fields(use all to extract) and apply custom sorting on new table and link to raw table fields to enable custom sorting.

Custom Sorting in Power BI 

BTW, you can take a look at below blog to know more about circular dependency issue: 

Avoiding circular dependency errors in DAX 

Regards,

Xiaoxin Sheng