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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
iluvaccounting1
Frequent Visitor

Updating DAX Expression Causes Errors!! HELP

When I'm updating the DAX expressions in calculated tables, the new column I am creating is replaced by the table with which I am working in. This only happens after I write the expression and click out of the input field. This is happening in multipe models that I have built that have no relation to each other, see screenshots below of a test example. Is this a known glitch or is there a solution to this?

iluvaccounting1_3-1709306685996.png

 

iluvaccounting1_2-1709306672243.png

 

iluvaccounting1_1-1709306656453.png

 

1 ACCEPTED SOLUTION

Figured it out, it is a bug in the latest update. I installed the December 2023 version of PowerBI and it works.

View solution in original post

5 REPLIES 5
vanessafvg
Super User
Super User

has anything in your data changed?  have you checked that there isn't some form of duplication happening, because something that might have worked before and if its affecting all your models but the common denominator is your data, it might be that something has changed.   

 

summarize would work off your relationships, so to me and i could be wrong it looks like its unable to resolve a single value for your calculated column.

 

can you share a screenshot of your model, and what the relationships look like?

 

that will also guide you to see if there is a duplication thats unexpected.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




@vanessafvgnothing in my data has changed. i did check to see if there was any duplication and there hasn't been. i should have been more clear, when i said it is affecting all of my models i meant all of my power bi data sets, which are separate from one another. i have another sample data set i have new screenshots from as the problem continues to persist. as you can see from the screenshots below, i can create a calculated column in the calcualted table but when when i click into a different column and click back in, it replaces the calculated column with the table.

iluvaccounting1_0-1709475265274.png

iluvaccounting1_1-1709475286286.png

iluvaccounting1_2-1709475302781.png

iluvaccounting1_3-1709475319076.png

 

 



Figured it out, it is a bug in the latest update. I installed the December 2023 version of PowerBI and it works.

amitchandak
Super User
Super User

@iluvaccounting1 , This can happen if you create a column in a table that is not Test. Or when you are creating a measure or Table

@amitchandak So this happens whether the column is called "Test" or not. In this instance the calculated table is called test and the column I'm creating is called test, but if I was to change the names I'd still run into the same issue.

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.