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 ( VA...
- This should work,Leave = CALCULATE ( COUNT ( Leavers[ID]) , Leavers[Status] = "Leave" )
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