circular dependency error

[Anonymous]

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 

( MINFAREKM = CALCULATE(distance[TRIPDISTANCE]/2-2 ))

rateslababvminfare=field in busdetails table

request your help to solve the issue

[Anonymous · Accepted solution]

I recommend trying to create the same expression as a measure instead.

[Anonymous · Accepted solution]

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 

[Anonymous · Accepted solution]

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. 

[Anonymous · Accepted solution]

Thank you once again, this one is more helpful 👍

[Anonymous]

Does it need to be a column or can you use a measure?

[Anonymous]

Dear bchager,

Column will be fine 

[Anonymous · Accepted solution]

I recommend trying to create the same expression as a measure instead.

[Anonymous]

sure, i will do that, thank you 

can you please explain why this circular reference issue came with column creation 

[Anonymous · Accepted solution]

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 

[Anonymous]

thank you very much , it was an enlightening experience

[Anonymous · Accepted solution]

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.