COUNTIFS in Power BI

[Stephie679]

Help! I'd like to convert a COUNTIFS statement from Excel to Power BI. In excel, I have a COUNTIFS statement as follows: =COUNTIFS(T:T,"F",AT:AT,"Management",BC:BC,"M10",BC:BC,"M11",BC:BC,"M12"). Essentially, what i want to do is count the number of "F" in a column if the F also has "Management" in another column and IF the F is also in Grade M10-M12.

Thank you

[JorgePinho · Accepted solution]

= CALCULATE(COUNT([GENDER]), [Gender] = "F", [Empl Class] = "Management", [Grade] = "M10" || [Grade] = "M11" || [Grade] = "M12")