Forum Discussion
Multiple Filters (COUNTROWS)
- 9 years ago
MaleCDEcount = CALCULATE(
COUNTROWS(Grades),
FILTER(Grades,Grades[Gender]="M"),
FILTER(Grades,
Grades[Grade]="c" || Grades[Grade]="d" || Grades[Grade]="e"))
My table is named 'Grades' - you will want to change this code to your table name.
MaleCDEcount = CALCULATE(
COUNTROWS(Grades),
FILTER(Grades,Grades[Gender]="M"),
FILTER(Grades,
Grades[Grade]="c" || Grades[Grade]="d" || Grades[Grade]="e")
)
My table is named 'Grades' - you will want to change this code to your table name.