Creating a new measure in report hangs the power bi

[KRISH80]

Hi All, 

When ever i create a measure within my power bi desktop, it takes agaes for the formual bar to come up. I have almost 100 mesaures already in my report. Is it because of that ? When ever i click 'New Measure', all slicers, visual starting rolling in that page. Screen shot below. Kindly help.

[Mariusz · Accepted solution]

Hi @KRISH80 

It's probably due to the size of your model in general, check your Memory capacity using Task Manager if you are hitting max, then try to optimize your report.
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[Mariusz · Accepted solution]

Hi @KRISH80 

It's probably due to the size of your model in general, check your Memory capacity using Task Manager if you are hitting max, then try to optimize your report.
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

https://docs.microsoft.com/en-us/power-bi/guidance/import-modeling-data-reduction

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
LinkedIn

[V-lianl-msft · Accepted solution]

Hi @KRISH80 ,

This should be a memory problem. You can use DirectQuery connection mode.

You can also refer to these articles to optimize DAX performance.

https://maqsoftware.com/expertise/powerbi/dax-best-practices 

https://www.sqlbi.com/articles/capturing-power-bi-queries-using-dax-studio/ 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.