Forum Discussion
Circular dependency using Calculate
Hi Anonymous,
In fact, this is a common issue appears when you duplicate reference across multiple calculated fields.
I'd like to suggest you measure expression instead calculate columns, you can check the below link about the difference between calculate column and measure:
Calculated Columns and Measures in DAX - SQLBI
In addition, you can also take a look at the following blog that mention the issue to know more about this sceariao:
Avoiding circular dependency errors in DAX - SQLBI
Regards,
Xiaoxin Sheng
Hi Anonymous
First, you should do such calculations in Power Query because this is the right tool for data transformations (DAX is a data analysis expression language). Second, you are getting this circular dependency error because you're using CALCULATE (directly or indirectly) in the calculated columns (by the way, there's no such thing like "column measures", either measures or calculated columns) and due to how CALCULATE works it's unavoidable. Third, you can (but you shouldn't) do the same calculations without any CALCULATE since in the row you've got all you need - a row context.