Forum Discussion
Circular dependency when adding calculated column
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:
2 Replies
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/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-kVery 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
