Help with a AND & Countrows Measure

[jcastr02]

Need help with a formula.  Looking to countrows of any Status that is equal to 'In Progress' AND the Overdue is equal to 'Yes.'  Also I'd like that if the count is blank to show "0"  vs. (blank).    I've gotten this far: but stuck....with the AND piece

Measure

# Overdue TeamMember = if(isblank(countrows(filter(filter('x-Coaching-Sharepoint','x-Coaching-Sharepoint'[Status]="In Progress"),'x-Coaching-Sharepoint'[OverdueTeamMember?]="Yes"))),0,countrows(filter(filter('x-Coaching-Sharepoint','x-Coaching-Sharepoint'[Status]="In Progress"),'x-Coaching-Sharepoint'[OverdueTeamMember?]="Yes")))

Example of Table

Date	Status	OverdueTeamMember?
11/1/2021	In Progress	Yes
11/2/2021	In Progress	Yes
11/3/2021	In Progress	Yes
11/4/2021	In Progress	No
11/5/2021	In Progress	No
11/6/2021	In Progress	No
11/7/2021	Draft	Yes
11/8/2021	Draft	Yes
11/9/2021	Draft	Yes
11/10/2021	Draft	Yes
11/11/2021	Draft	Yes

[lbendlin]

Your request is not completely clear. Which visual will contain the measure and how?

Measure = CALCULATE(COUNTROWS(ALLSELECTED('Table')),'Table'[Status]="In Progress",'Table'[OverdueTeamMember?]="Yes")+0