Forum Discussion

RichWyeth's avatar
RichWyeth
Frequent Visitor
9 years ago
Solved

Multiple Filters (COUNTROWS)

Hi,   I am struggling to get a result for COUNTROWS based on multiple critera. From the table I am trying to filter all Males with a grade of either C,D or E and to give me the count of rows.    ...
Need Help
  • CahabaData's avatar
    CahabaData
    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.

     

wonga's avatar
wonga
Continued Contributor
9 years ago

RichWyeth

 

Another potential implementation could be:

 

CALCULATE(
    COUNTA(Tbl_ORG001), Tbl_ORG001[HCD_Gender] = "M",
        OR(Tbl_ORG001[HCD_Band] = "C",
            OR(Tbl_ORG001[HCD_Band] = "D", Tbl_ORG001[HCD_Band] = "E",)
           )
    )

This applies a filter of Male and considers all rows that have a grade of either C, D or E and returns a count of rows that satisfy that filter.