How can I inclound another logic in COUNTAX

[Anonymous]

Hello great minds:

As a new learner of Power BI, stuck in processing. 

I want to  Count without blank where Overall status is "Completed" and "in progress". 

Overll status is another coloumn

Measure PWC Complete Count = COUNTAX(Table_query__1,Table_query__1[PwC Actual Complete Date])

Appreciate your help in processing the logic. 

Thanks

[Anonymous]

Appreciate your help in my learnig process. Great help.

[Greg_Deckler · Accepted solution]

@Anonymous Try:

Measure PWC Complete Count = COUNTX(FILTER(Table_query__1, [PwC Actual Complete Date <> BLANK() && ( [Overall status] = "Completed" || [Overall status] = "in progress" ) ) ,Table_query__1[PwC Actual Complete Date])