Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Circular dependency using Calculate

For a calculation I have created two column measures. The first (NewTable[empty count]) calculates the # empty values in a row, the second (NewTable[totalcount] calculates # values in the row that ar...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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