Calculated column does not work

[mariorodrigues]

I have a calculated column in Power Bi, which, when trying to change the formula, returns to the formula it was in before, and does not show any errors.
Ex:
CalculatedColumn = 0
Change to
Calculated Column = CALCULATE(SUM(AvulsoCostRateio[PerctProjeto]))

Power Bi returns the value to the initial value which is "0", in this example

[Sahir_Maharaj]

Hello @mariorodrigues ,

Can you please try these troubleshooting steps to ensure that the change is applied:

1. Save Changes: After modifying the formula for a calculated column, make sure to click the "Enter" key or click outside the formula input area to apply the changes.

2. Check for Syntax Errors: Ensure that the new formula does not contain any syntax errors. Any errors in the formula can prevent it from being applied. If there are syntax errors, Power BI might not accept the change.

3. Refresh Data: Sometimes, Power BI might not update the calculated column immediately in the data view. Try refreshing your data by clicking the "Refresh" button in the Power Query Editor or by refreshing the dataset in Power BI Desktop.

4. Column Name Conflicts: Ensure that there are no naming conflicts with existing columns in your table. If the new calculated column has the same name as an existing column, it may not apply the change.

5. Column Dependencies: Check if the new formula depends on other calculated columns or measures. If those dependencies are not met, it can prevent the change from being applied. Ensure that all required columns and measures are correctly defined.

6. Check for Filters: Ensure that there are no filters applied to your report that are affecting the visibility of the updated calculated column. Filters can affect which columns are displayed in your visualizations.

Should you require further details or information, please do not hesitate to reach out to me.

[mariorodrigues]

@Sahir_Maharaj 

Among the problems listed the most likely is 5, column dependencies, because the values in the column calculates have values from a calculated table. So I'm revising this table to be able to assemble the data as needed.

Thank you very much for the support.