Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Measure taking too long to load

I created a measure to be used in a line graph that shows the number of nationalities over time.   However the visual is taking too long to load with over 250,000ms (from performance analyser).   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

You have use variables and selectvalue() which we could do to optimise dax. Your code is easy and I think there is no place for us to change on it. As far as I know, measure return too long may also caused by many other conditons.

You can optimize your solution at different architectural layers. Layers include:

  • The data source(s)
  • The data model
  • Visualizations, including dashboards, Power BI reports, and Power BI paginated reports
  • The environment, including capacities, data gateways, and the network

Here I suggest you to refer to below offical blog to learn more details.

For reference: Optimization guide for Power BI

 

Best Regards,
Rico Zhou

 

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