It is possible for columns and measures to also exhibit circular dependencies. To demonstrate, follow these steps:
- In R09_Table, create the following columns:
Column = 'R09_Table'[Value] * 100
Column 2 = 'R09_Table'[Value] * 'R09_Table'[Column]
- Now, change the formula for Column as shown:
Column = 'R09_Table'[Value] * 'R09_Table'[Column 2]
Note that a circular dependency error is displayed and that both Column and Column 2 are blanked out.
The fix in this case is obvious; simply create a single column with the following formula:
Column = 'R09_Table'[Value] * 100 * 'R09_Table'[Value]
However, there are instances where DAX's precise detection of a circular reference can be maddeningly obscure.