Forum Discussion
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). ...
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