Filter view in Calendar

[Boa_Casa]

Hi,

I have a calendar view which has a filter table where I can filter by date,event type,event status and in slice I have written the below expression. Though the expression isnt showing an error still the data isnt getting filtered accordingly. If some guidance could be given on whats going wrong?

Expression:

OR
([Event Date]<=ANY(Search Table[F_Date]),[Event Date]>=ANY(search table[To date]),([Event Type]=ANY(Search Table[Event Type])))

[1minManager]

Suspect it realtes to this bit

Boa_Casa:

[Event Type]=ANY(Search Table[Event Type])

You either need to change to an ANY(select(… to pick one item or to an IN(“Search Term”,Search Table[Event Type]). Since as it is it looks like it might just be getting the first record in thg table

Simon@1minManager.com