Table visual loading slow / High DAX duration

Thank you Greg_Deckler  and elitesmitpatel , your ideas is great!

Hi, amir_mm 

Optimizing DAX queries can be challenging. We can work together with Power BI's built-in profiling tools and external tools to achieve this goal.
First, we can use the Performance analyzer that comes with Power BI Desktop:

We can find the tutorial on how to use this tool from the following link:

Use Performance Analyzer to examine report element performance in Power BI Desktop - Power BI | Microsoft Learn

Any actions you take in the report are displayed and recorded in real time in the Performance Analyzer pane in the order in which Power BI loads the visuals.
Performance Analyzer is looking at how long it takes for each visual to query the data model and render the results. This is the time (in milliseconds) from when the user performs something on the page to when the visual is rendered.

The official documentation also has an optimization guide where you can get some tips for optimizing the user experience:

Optimization guide for Power BI - Power BI | Microsoft Learn

Secondly, we can use external tools such as DAX studio, daxoptimizer, etc. When you use these tools, you need to follow the official documentation of the corresponding tools to understand the metrics. 

The following article describes the practices for optimizing DAX:

Optimizing DAX expressions involving multiple measures - SQLBI

Best Regards

Jianpeng Li

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