Showing results for 
Search instead for 
Did you mean: 
Not applicable

Unable to create a measure in Power BI File

Hi Experts


I have a Power BI File which has been working just fine until today - when i try to add a measure to a measures table the file just hangs - previously this was not the issue - i have updated Power BI Desktop to Sept 21. I am working with Direct Query in my report. 


I am connecting to Redshift db back end. I cannot work out why the file it not allowing me to add new mesures to any table.

Community Support
Community Support

Hi @Anonymous ,

Does your problem still persist? Is there an old existing measure in your pbix file? Please use Performance Analyzer to examine the report element performance in the file and check if there is any element that are not performing well. Later validate if you can create new measure after optimizing these...

Introducing Performance Analyzer in Power BI Desktop

Using The Performance Analyzer In Power BI - Model Optimization Tips

By the way, can you create new measure in other existing pbix files or a brand new pbix file? 

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Super User
Super User

@Anonymous You could check the Issues forum here:

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to Scroll down and click "CREATE SUPPORT TICKET".

@ me in replies or I'll lose your thread!!!
Check out my External Tool for Power BI Desktop! Microsoft Hates Greg's Quick Measures
YouTube Channel! Microsoft Hates Greg
Check out my latest book!

Not applicable

thanks Greg

Helpful resources

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Top Solution Authors
Top Kudoed Authors