Forum Discussion
Solved
COUNTIFS in Power BI
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
= CALCULATE(COUNT([GENDER]), [Gender] = "F", [Empl Class] = "Management", [Grade] = "M10" || [Grade] = "M11" || [Grade] = "M12")
1 Reply
- JorgePinho
Solution Sage
= CALCULATE(COUNT([GENDER]), [Gender] = "F", [Empl Class] = "Management", [Grade] = "M10" || [Grade] = "M11" || [Grade] = "M12")