Frustrating inability to re-edit dax measure expression

[trevb]

Okay.  I wrote a measure which was quite complex but worked well.  I moved on to soe mother measures and then noticed that this measure now had an exclaimation mark in front of it.

When I click on it it says "To use special characters in a measure name, enclose the entire name in brackets ([] and add a ] to any closing brackets in the name."

Helpful message with a but.  With the message showing I cannot in anyway see the original expression to check this.  I know I did not use special characters but without being able to access the expression I can do nothing to fix it.  I have tried expanding the formula box but it is still empty, no way to edit.

I need this so I will now go and delete the original and rebuild the expression.  I would be interested to know if there is a way to see the underlying code for future repairs though.  In the power query editor you can get around this kind of challenge with the advanced editor.  Any pointers would be gratefully received.

[trevb]

Have just noticed that a number of the original measures have now gone.  This suggests to me that something got corrupted and thus the feeling of the system that one of the names has a special character in it.  Now I'm going to drop the whole file and go back to the original so I don't leave some kind of corruption in there as a sleeping issue for further down the line.

clearly info on how to see the definitions of the measures would be really useful.  I suspect it is more excel than power query though 😞

[kcantor]

@trevb

Could you post a screen capture? Anytime I have run into an error in my DAX I have been able to move to the data model and see the expression by selecting it.

[trevb]

Sadly I can't.  I dumped the file so that I did not end up corrupting my original working stuff.  If it happens again when I've rebuilt my work I will post it.