Forum Discussion

romovaro's avatar
romovaro
Icon for Responsive Resident rankResponsive Resident
4 years ago

Adding new requirement formula

  Trying to add a new requirement in the formula Formulas are working fine but now I need to add an extra filter   && (Task = "IPM HandOff) and Task Status Closed   Tried to add:   CALCULATE...
Need Help
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
4 years ago

romovaro ,It should work , try like

CALCULATE(COUNTROWS(CELERGO_12062021V1),Filter( CELERGO_12062021V1, CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed"))

 

or

 

Partner Acknowledgment with GLD = CALCULATE (COUNTA ( CELERGO_12062021V1[SCHEDULED] ), filter(CELERGO_12062021V1, CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement" ))
)