Measure with a filter clause

[AkhlaqQuestions]

Hi all

How do I create a Measure that does a count along with a filter (WHERE CLAUSE in SQL) for the word Leave in the status column

Leave  =

CALCULATE ( COUNT ( Leavers[ID]

FILTER ( VALUES ( ( Leavers, Leavers[Status] = "Leave" ))

Am I using the correct syntax?

[aj1973 · Accepted solution]

Hi @AkhlaqQuestions 

This should work,

Leave = CALCULATE ( COUNT ( Leavers[ID]) , Leavers[Status] = "Leave" )

[AkhlaqQuestions]

Thanks for the reply, 
Getting an error message

Too many arguments were passed to the COUNT function. The maximum argument count for the function is 1.

[aj1973]

Try again please I just edited the measure