Performance improvement

Hi vvirul ,

Please try this.

Response % Complete Overtime =

var max_date = LASTDATE('Date Table'[Date])
var temp = FILTER('Date Table', 'Date Table'[Date] <= max_date)

var running_total = CALCULATE(
 countrows(Responses_overtime),
 Responses_overtime[status] <> BLANK(),
 USERELATIONSHIP('Date Table'[Date],Responses_overtime[updated_date]),
  temp)
 
var number_needed = CALCULATE(
 countrows(Responses_overtime),
 USERELATIONSHIP('Date Table'[Date],Responses_overtime[updated_date]),
 temp)

var result = DIVIDE(running_total, number_needed, BLANK())
return result

You can also optimize the performance by optimizing the model, etc.

Refer : Optimization guide for Power BI - Power BI | Microsoft Learn

Power BI Performance Optimization Tips (mssqltips.com)

Best Regards,

Neeko Tang

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