Forum Discussion

guillouzada's avatar
guillouzada
Frequent Visitor
5 years ago
Solved

Slow DAX Formula Bar Input (Intellisense)

In Power BI Desktop DAX formula bar text input is very slow for bigger measures (greater than 50 lines). And it gets worst with measure size increase. This is NOT the measure performance but the tex...
Need Help
  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi guillouzada ,

    Based on my test, DAX studio works better than power bi when writing more than hundreds rows of DAX statement in this case, so I think could be a solution to help you.

     

    Best Regards,
    Yingjie Li

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

Pragati11's avatar
Pragati11
Super User
5 years ago

Hi guillouzada ,

 

Just thinking now if is it really right to create a 1500+ lines of DAX code for a calculated table in Power BI.

What's the requirement that is making you do that?

guillouzada's avatar
guillouzada
Frequent Visitor
5 years ago

This case is only an example for my issue but I have other with big measures also.

 

I use those for measures and visuals performance improvement. Some cases that I'd use 30+ cards in the same page I can use only 1 visual with HTML. In this one we could drop the refresh time from 30s to 50~100ms.

 

 

 

  • v-yingjl's avatar
    v-yingjl
    Community Support
    5 years ago

    Hi guillouzada ,

    Currently the DAX Formula Bar is expanded automatically by your dax statement and can only be zoomed. If you think the formula is slow, perhaps you can try to write it in DAX studio and paste it in power bi desktop to check whether it could help you.

     

     

    Best Regards,
    Yingjie Li

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

     

     

    • guillouzada's avatar
      guillouzada
      Frequent Visitor
      5 years ago

      Hello v-yingjl ,

       

      Sure it could be a workaround but not a solution, right? While I don't find any I can sure use DAX Studio.

       

      Thank you!

       

      Best Regards,

      Guilherme

      • v-yingjl's avatar
        v-yingjl
        Community Support
        5 years ago

        Hi guillouzada ,

        Based on my test, DAX studio works better than power bi when writing more than hundreds rows of DAX statement in this case, so I think could be a solution to help you.

         

        Best Regards,
        Yingjie Li

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