Hi i am trying to write a DAX for the count of On Notice, Active, Inactive employees, and i wrote

[Ramyaajithkumar]

Hi i am trying to write a DAX for the count of On Notice, Active, Inactive employees, and i wrote this below command and i am new to powerbi

M_Act_emp1 = CALCULATE(COUNTROWS('Attrition 1'),FILTER('Attrition 1',('Attrition 1'[Status] ="Active"),FILTER('Attrition 1',('Attrition 1'[Status] = "On Notice"))))

It says

Too many arguments were passed to the FILTER function. The maximum argument count for the function is 2.

can anyone can help and send your suggestion raaj@enabl.dk

[wdx223_Daniel · Accepted solution]

M_Act_emp1 = CALCULATE(COUNTROWS('Attrition 1'),'Attrition 1'[Status] IN {"Active","On Notice"})

[Ramyaajithkumar]

Thank you very much