cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
RichWyeth
Frequent Visitor

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. 

 

This is what I have:

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

 

This does not come back with an error, but just displays nothing in the column.

 

Can anyone help?

1 ACCEPTED SOLUTION
CahabaData
Memorable Member
Memorable Member

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.

 

www.CahabaData.com

View solution in original post

2 REPLIES 2
wonga
Continued Contributor
Continued Contributor

@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.

CahabaData
Memorable Member
Memorable Member

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.

 

www.CahabaData.com

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors