Adding new requirement formula

[romovaro]

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(COUNTROWS(CELERGO_12062021V1),CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed"))) but is not working

Could you help me? 

Total Tasks = CALCULATE ( COUNTA ( CELERGO_12062021V1[TASK] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement"))….+ Extra Filter

Showing Total of tasks that contains the string “Partner Acknowledgement” and have task “IPM HandOff” closed.

Partner Acknowledgment with GLD = CALCULATE ( COUNTA ( CELERGO_12062021V1[SCHEDULED] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement" )) ….+ Extra Filter

Showing Total of tasks that contains the string “Partner Acknowledgement” , have a schedule date and have task “IPM HandOff” closed.

Partner Acknowledgment with GLD & Closed = CALCULATE ( COUNTA ( CELERGO_12062021V1[SCHEDULED] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement" ) && CELERGO_12062021V1[TASK_STATUS] = "Closed" ) ….+ Extra Filter

Showing Total of tasks that contains the string “Partner Acknowledgement” and task status Closed, have a schedule date and have task “IPM HandOff” closed.

Thanks

[v-jingzhang]

Hi @romovaro 

This topic is similar to this thread you posted earlier, can you help close this one? Thank you. You can accept a reply as solution to close it. 

Best Regards,
Community Support Team _ Jing

[romovaro]

Hi amitchandak

In the formula below it's missing the fields with the string "partner Acknowledgment"

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

Total Tasks = CALCULATE ( COUNTA ( CELERGO_12062021V1[TASK] ), CONTAINSSTRING ( CELERGO_12062021V1[TASK], "Partner Acknowledgement")).... and I am trying to add...the filter to add...and 

CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed")

My problem is adding this "extra requirement" in the 3 formulas above.

CELERGO_12062021V1[TASK] ="IPM HandOff" && CELERGO_12062021V1[TASK_STATUS]="Closed")

[amitchandak]

@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" ))
)