Forum Discussion

jcastr02's avatar
jcastr02
Post Prodigy
4 years ago

Help with a AND & Countrows Measure

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
DateStatusOverdueTeamMember?
11/1/2021In ProgressYes
11/2/2021In ProgressYes
11/3/2021In ProgressYes
11/4/2021In ProgressNo
11/5/2021In ProgressNo
11/6/2021In ProgressNo
11/7/2021DraftYes
11/8/2021DraftYes
11/9/2021DraftYes
11/10/2021DraftYes
11/11/2021DraftYes

 

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    4 years ago

    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