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"). Ess...
= CALCULATE(COUNT([GENDER]), [Gender] = "F", [Empl Class] = "Management", [Grade] = "M10" || [Grade] = "M11" || [Grade] = "M12")
JorgePinho
Solution Sage
Solution Sage= CALCULATE(COUNT([GENDER]), [Gender] = "F", [Empl Class] = "Management", [Grade] = "M10" || [Grade] = "M11" || [Grade] = "M12")