Isblank, calculate, distinctcount, filter issue

[Craigc3814]

I am working on this formula (sorry for the format). I need the ability to count multiple P6Projects[TASKNAME] I am pretty sure I need to incorporate Filter into the measure but I am unsure of how to do so, does it come after the (DISTINCTCOUNT('P6Projects'[PROJECTID])

I need to count a task name called Operational ready, and WWIP Operation Ready as well as Construction Substantial Completion. This whole measure is due to the fact hat if I just use filters on the page blank returns rather than 0

SC count = if(isblank(CALCULATE(DISTINCTCOUNT('P6Projects'[PROJECTID]),'P6Projects'[TASKNAME]="Construction Substantial Completion")),0,CALCULATE(DISTINCTCOUNT('P6Projects'[PROJECTID]),'P6Projects'[TASKNAME]="Construction Substantial Completion"))

 

[Craigc3814]

I am working on this formula (sorry for the format). I need the ability to count multiple P6Projects[TASKNAME] I am pretty sure I need to incorporate Filter into the measure but I am unsure of how to do so, does it come after the (DISTINCTCOUNT('P6Projects'[PROJECTID])

I need to count a task name called Operational ready, and WWIP Operation Ready as well as Construction Substantial Completion. This whole measure is due to the fact hat if I just use filters on the page blank returns rather than 0

SC count = if(isblank(CALCULATE(DISTINCTCOUNT('P6Projects'[PROJECTID]),'P6Projects'[TASKNAME]="Construction Substantial Completion")),0,CALCULATE(DISTINCTCOUNT('P6Projects'[PROJECTID]),'P6Projects'[TASKNAME]="Construction Substantial Completion"))

Got it figured out if anyone every runs into the same issue

if(isblank(CALCULATE(DISTINCTCOUNT('P6Projects'[PROJECTID]), Filter(ALL(P6Projects),P6Projects[TASKNAME] = "WWIP SC - Operational Ready/Beneficial Use"&& P6Projects[TASKNAME] = "Operational Ready/Beneficial Use"))),0,CALCULATE(DISTINCTCOUNT('P6Projects'[PROJECTID]), Filter(ALL(P6Projects),P6Projects[TASKNAME] = "WWIP SC - Operational Ready/Beneficial Use"&& P6Projects[TASKNAME] = "Operational Ready/Beneficial Use")))