Circular dependency when adding calculated column

[Syndicate_Admin]

Good morning

I have the following problem:

I have 2 tables, related to 1 to 1. They are related by budget number, since it is unique for each one.

I have a measure that is: Total cost as of today (table 1, Current construction costs)/Projected cost (table 2 Projects). The name of the measure: [%_Ejecución_proyecto]

Then, I want to make a column where, according to the % that gives me the previous measure, indicate if it is: Aprov. Material, Initial phase, Execution, Final work and exceeded (if the division is above 1).

Then, I apply the following formula for the calculated column:

Estado_proyecto = Switch( True(),

[%_Ejecución_proyecto] < .15 , "1-Appv. Material",

[%_Ejecución_proyecto] < .35 , "2-Initial",

[%_Ejecución_proyecto] < .75 , "3-Execution",

[%_Ejecución_proyecto] < .99 , "4-Final",

"Over budget"

)

At the end, I get an error: Circular dependance.

I don't understand why.

Can you help me?

Thanks a lot.

Greetings to the whole community.

[Syndicate_Admin]

Very good,

It has worked, thank you very much.

With the formula and the process that you have informed me I have been able to assemble a column graph where it shows me, according to the condition, the number of projects I have (initial phase, execution, etc.)

What I wanted is that, selecting one of them, in the matrix where I have the detail of all the budgets, it showed me those that are in the initial phase.

I have followed the tutorial provided and, of course, I do not have to relate the table of budget status conditions with the table where all the budgets appear.

How could I relate them?, so that selecting in the graph only the budgets in the initial phase, in the matrix I would be shown the budgets in the initial phase.

Thanks again.

Best regards

[amitchandak]

@Syndicate_Admin , You can not create a column on a measure. For what you have show you need a table and bucketing

refer examples

Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1...

Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k