Forum Discussion
circular dependency error
Hi,
I tried to create a New Column as shown in screenshot but got an error message as displayed ;
busdetails = table in which am trying to create new column
minfarekm = measure for calculating the minimum fare km by refering to a field in the table named Distance
rateslababvminfare=field in busdetails table
request your help to solve the issue
I recommend reading what Marco Russo wrote about the differences between calculated columns and measures for the best answer to your question: Calculated Columns and Measures in DAX
You're welcome. Creating a measure in place of a calculated column has worked for me as a quick fix, but it might not always be the right solution. The SQLBI guys explain how to handle circular dependencies while maintaining a calculated columns, here.