COUNTIFS power query ?

[Anonymous]

Hello everyone,

i really need your help about an issue which is HOW TO USE A COUNTIF FUNCTION ON POWER QUERY ?

i would like to create a measure like that :

=(COUNTIFS('Suivi collab N-1'!$F:$F;"Non";'Suivi collab N-1'!$W:$W;"Actif";'Suivi collab N-1'!$L:$L;"AUDIT";'Suivi collab N-1'!$CK:$CK;"Encadrement")

In power BI :

$W:$W = column "EST"
$W$W = column "statut"

$L$L = column "UG"

$CK:$CK = column "Managers"

I know to do that with ONE criteria for example : countrows(filter(Table1;Table[ColumnName]="CRITERIA"))

But how to do that with multiple criteria ?

I'm sorry for my bad english. I'm trying to do my best to be understood.

thank you a lot for you help !