Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

using two filters one with text and one date

So I need a measure which shows a count of members who have raised a case in the current month, who have an eligibility flag of "yes" So I can do a distinct count of member ID for the number of memb...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Riantilo  you almost had it, without closing off the &&Year with three close brackets the measure believes the final filter is for the YEAR argument. 

    So the below works! Thanks for your help! :-) 

    Eligible Members this Month =
CALCULATE(
DISTINCTCOUNT('Members'[MemberID]),
MONTH('Case'[Createdon])=month(TODAY()) &&
YEAR('Case'[Createdon]=YEAR(TODAY())) ,
FILTER(
'Members',
'Members'[Eligible]="Yes"
)
)
Riantilo's avatar
Riantilo
Frequent Visitor
7 years ago

I think u can fix this bij changing the last && to a , 

This should work:
Eligible Members this Month =
CALCULATE(
DISTINCTCOUNT('Members'[MemberID]),
MONTH('Case'[Createdon])=month(TODAY()) &&
YEAR('Case'[Createdon]=YEAR(TODAY()) ,
FILTER(
'Members',
'Members'[Eligible]="Yes"
)
)

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Riantilo  you almost had it, without closing off the &&Year with three close brackets the measure believes the final filter is for the YEAR argument. 

    So the below works! Thanks for your help! :-) 

    Eligible Members this Month =
CALCULATE(
DISTINCTCOUNT('Members'[MemberID]),
MONTH('Case'[Createdon])=month(TODAY()) &&
YEAR('Case'[Createdon]=YEAR(TODAY())) ,
FILTER(
'Members',
'Members'[Eligible]="Yes"
)
)
    • Riantilo's avatar
      Riantilo
      Frequent Visitor
      7 years ago

      I copied the code from the original post. And dit not see that mistake. 

      YEAR('Case'[Createdon]=YEAR(TODAY()))

       That explains why it didn't work.

       

      to explain the error: The FILTER function can only be used in its own CALCULATE filter expression and can not be combined with the && or || operators.