INTERSECT makes detail view disappear

I have a SELECT expression to list volunteers available due to criteria

SELECT(Volunteer Hours[Volunteer],
AND(IN([_THISROW].[Job Experience], [Experience]),
IN([_THISROW].[Day Number App Formula], [Days from info])))

This works, but I want to add in INTERSECT to check if they are already allocated another job at this time to leave them out of the list.

SELECT(Volunteer Hours[Volunteer],
AND(IN([_THISROW].[Job Experience], [Experience]),
IN([_THISROW].[Day Number App Formula], [Days from info]),
ISBLANK(
INTERSECT(
(LIST() + [List Volunteer Text Times 15 mins]),
(LIST() + [_THISROW].[List Session Text Times 15 mins])
)))
)

When I add the INTERSECT the detail view doesn’t show when I click through to it.
Some do and they don’t have a list of volunteers, so I guess that’s why they show.

If I untick Show for this column the detail views all show.

I have used this expression the other way round, on the table of volunteers, checking which jobs they can do and that works fine

SELECT(All Days Slice[Unique ID],
OR([_THISROW].[Volunteer]=[Volunteer],
AND(ISBLANK([Volunteer]),
CONTAINS([_THISROW].[Experience],[Job Experience]),
CONTAINS([_THISROW].[Days from info],[Day Number App Formula]),
ISBLANK(
INTERSECT(
(LIST() + [_THISROW].[List Volunteer Text Times 15 mins]),
(LIST() + [List Session Text Times 15 mins])
))
)
))

In my experience, this happens because of a bug in the expression internals. The best you can try for is a work-around.

That’s a shame.
Do you know a workaround I can use to compare 2 lists?

1 Like

Instead of ISBLANK(INTERSECT(...)), you might consider whether this would work for you:

ISBLANK(
  [List Session Text Times 15 mins]
  - [_THISROW].[List Volunteer Text Times 15 mins]
)

or this:

ISBLANK(
  [_THISROW].[List Volunteer Text Times 15 mins]
  - [List Session Text Times 15 mins]
)

See also:

1 Like

Thanks Steve. I’ll give that a go.

1 Like