Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |