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" )
aj1973's avatar
aj1973
Community Champion
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
      Community Champion
      3 years ago

      Try again please I just edited the measure