Tuning my report

PBI5851 , Change this measure  and try

countrows(summarize(FILTER(Job_Source, Job_Source[New_Job_Value]= "Complete"),JobSource[Job_Name]))

Hi  PBI5851 ,

You can change the formula to the following form:

Measure =
CALCULATE(DISTINCTCOUNT(JobSource[Job_Name]),FILTER(ALL(JobSource),
'JobSource'[New_Job_Value]="Complete"))

You can try the following methods:

1. You can use the external tool DaxStudio to find the maximum run and analyze it.

https://daxstudio.org/

2. Are you using the Import connection mode, you can change it to the Direct query connection mode to speed up the refresh rate.

 https://community.powerbi.com/t5/Desktop/DAX-and-Power-BI-Optimization/m-p/268589

Optimize the model in power bi to reduce unnecessary columns and data.

https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization

 https://community.powerbi.com/t5/Desktop/Transformations-in-Power-Query-Very-Slow-Performance/td-p/584292

Dax optimization:

https://maqsoftware.com/insights/dax-best-practices

Modeling optimization:

https://community.powerbi.com/t5/Desktop/DAX-optimization/td-p/946984

 

Best Regards,

Liu Yang

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