Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
mariorodrigues
Regular Visitor

Calculated column does not work

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

2 REPLIES 2
Sahir_Maharaj
Super User
Super User

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.


Did I answer your question? Mark my post as a solution, this will help others!

If my response(s) assisted you in any way, don't forget to drop me a "Kudos" 🙂

Kind Regards,
Sahir Maharaj
Data Scientist | Data Engineer | Data Analyst | AI Engineer
P.S. Want me to build your Power BI solution?
➤ Lets connect on LinkedIn: Join my network of 13K+ professionals
➤ Join my free newsletter: Data Driven: From 0 to 100
➤ Website: https://sahirmaharaj.com
➤ Email: sahir@sahirmaharaj.com
➤ Want me to build your Power BI solution? Lets chat about how I can assist!
➤ Join my Medium community of 30K readers! Sharing my knowledge about data science and artificial intelligence
➤ Explore my latest project (350K+ views): Wordlit.net
➤ 100+ FREE Power BI Themes: Download Now
LinkedIn Top Voice in Artificial Intelligence, Data Science and Machine Learning

@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.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors