Forum Discussion

AkhlaqQuestions's avatar
AkhlaqQuestions
New Member
3 years ago
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...
Need Help
  • aj1973's avatar
    aj1973
    3 years ago
    This should work,
    Leave = CALCULATE ( COUNT ( Leavers[ID]) , Leavers[Status] = "Leave" )
AkhlaqQuestions's avatar
AkhlaqQuestions
New Member
3 years ago

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's avatar
aj1973
Icon for Community Champion rankCommunity Champion
3 years ago

Try again please I just edited the measure