Forum Discussion
Solved
Measure with a filter clause
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?
Am I using the correct syntax?
- This should work,Leave = CALCULATE ( COUNT ( Leavers[ID]) , Leavers[Status] = "Leave" )
3 Replies
- This should work,Leave = CALCULATE ( COUNT ( Leavers[ID]) , Leavers[Status] = "Leave" )
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.Try again please I just edited the measure
