having issues with visuals refreshing slowly

[ukeasyproj]

I suspect its this measure that is causing the slow down:

count of ontime = IF( ISBLANK(CALCULATE(DISTINCTCOUNT([ProjectID]), FILTER('TT_ProjectMembers', [Completion Status of Project] = "On Time" && [Count me] = "Yes" ))) = FALSE() , CALCULATE(DISTINCTCOUNT([ProjectID]), FILTER('TT_ProjectMembers', [Completion Status of Project] = "On Time" && [Count me] = "Yes" )), IF( ISBLANK(CALCULATE(DISTINCTCOUNT([ProjectID]), FILTER('TT_ProjectMembers', [Completion Status of Project] = "Late" && [Count me] = "Yes" ))) = FALSE(), 0, BLANK() ))

any guidance on how to make this measure more efficient will be appreciated

[Anonymous]

Hi @ukeasyproj,

You can try to use below formula if it works on your side.

count of ontime = 
var temp = FILTER('TT_ProjectMembers', [Count me] = "Yes" )
var OnTime =CALCULATE(DISTINCTCOUNT([ProjectID]), FILTER(temp,  [Completion Status of Project] = "On Time"))
var Late =CALCULATE(DISTINCTCOUNT([ProjectID]), FILTER(temp,  [Completion Status of Project] = "Late"))
return
IF(OnTime>0, OnTime,IF(Late>0,0,BLANK()))

Regards,

Xiaoxin Sheng