Filter Calendar Slice Based on Enum list, Show single name if there's multiple attendees

[Jraff29]

AND(
IF(
ISNOTBLANK(ANY(Calendar Template[Title])),
[Title] = ANY(Calendar Template[Title]),
TRUE
),
IF(ISBLANK(ANY(Calendar Template[Techs])), TRUE,
IN([Attendees], SPLIT(Calendar Template[Techs],","))),

IF(
ISNOTBLANK(ANY(Calendar Template[Start])),
[Start] >= ANY(Calendar Template[Start]),
IF(
ISNOTBLANK(ANY(Calendar Template[End])),
[End] <= ANY(Calendar Template[End]),
TRUE
)
)
)

I'm using this expression on my calendar slice.  I'm running into the issue when the slice is filtered by the enum list Calendar Template[Techs] it only shows an event if I have both attendees selected in my enum list. My goal is to have it show all Events for an attendee even if there are multiple attendees on any given event.  

[Denny774]

Hey,

what happens if you use CONTAINS instead of IN?

[Jraff29]

It does the same thing.  I had it setup with contains first.  I'm sure I'm doing something wrong but I can't sort out where the issue is.

[AleksiAlkio]

If the Attendees column is an EnumList, the IN() won't work.. CONTAINS() won't work either. You can't compare list against list with IN().

[Jraff29 · Accepted solution]

Appreciate the help.  Got it resolved.

AND(
IF(
ISNOTBLANK(ANY(Calendar Template[Title])),
[Title] = ANY(Calendar Template[Title]),
TRUE
),
IF(Isnotblank(INdex(Calendar Template[Techs],1)),
IsNotBLANK(Intersect([Attendees],Split(INdex(Calendar Template[Techs],1),","))),True)
,
IF(
ISNOTBLANK(ANY(Calendar Template[Start])),
[Start] >= ANY(Calendar Template[Start]),
IF(
ISNOTBLANK(ANY(Calendar Template[End])),
[End] <= ANY(Calendar Template[End]),
TRUE
)
)
)