How can I count on a multiple text filter

Question

I am trying to count the number of "Other" leaves.&nbsp;This returns 0, as we can't count on a multiple filter, any ideas as to how to resolve in a measure?&nbsp;Count of Other LWOP = CALCULATE(&nbsp; &nbsp; COUNTA('Demographic'[Leave Type]),&nbsp; &nbsp; 'Demographic'[Leave Type] IN {&nbsp; &nbsp; &nbsp; &nbsp; "Family Related and Personal Leave without Pay &gt; Care and Nurturing LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Family Related and Personal Leave without Pay &gt; Maternity LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Family Related and Personal Leave without Pay &gt; Maternity LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Family Related and Personal Leave without Pay &gt; Parental LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Family Related and Personal Leave without Pay &gt; Parental LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Family Related and Personal Leave without Pay &gt; Relocation of Spouse LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Leave without Pay &gt; Sick LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Other Leave without Pay &gt; Educational LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Other Leave without Pay &gt; Long-Term Disability LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Other Leave without Pay &gt; Other LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Other Leave without Pay &gt; Self Funded LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Other Leave without Pay &gt; Suspension/Disciplinary Action LWOP",&nbsp; &nbsp; &nbsp; &nbsp; "Other Leave without Pay &gt; Union Business LWOP"&nbsp; &nbsp; })

greg_deckler · Accepted Answer

TeamCanada26__&nbsp;Perhaps try:
Measure = 
  VAR __Table = FILTER('Demographic',[Leave Type] IN {
        "Family Related and Personal Leave without Pay &gt; Care and Nurturing LWOP",
        "Family Related and Personal Leave without Pay &gt; Maternity LWOP",
        "Family Related and Personal Leave without Pay &gt; Maternity LWOP",
        "Family Related and Personal Leave without Pay &gt; Parental LWOP",
        "Family Related and Personal Leave without Pay &gt; Parental LWOP",
        "Family Related and Personal Leave without Pay &gt; Relocation of Spouse LWOP",
        "Leave without Pay &gt; Sick LWOP",
        "Other Leave without Pay &gt; Educational LWOP",
        "Other Leave without Pay &gt; Long-Term Disability LWOP",
        "Other Leave without Pay &gt; Other LWOP",
        "Other Leave without Pay &gt; Self Funded LWOP",
        "Other Leave without Pay &gt; Suspension/Disciplinary Action LWOP",
        "Other Leave without Pay &gt; Union Business LWOP"
      }
  )
RETURN
  COUNTAX(__Table,[Leave Type])

Forum Discussion

Related content

Distinct count with multiple filters

Filter participant counts

Filter and Count

Counting nulls

Multiple Years Filter