Enumlist is true

[Shock]

Hello,

I have an Apparatus table as my parent table. I have an apparatus Inventory table as the child and a Vehicle check list table also as a child table. 

I am correctly pulling my inventory items from the Vehicle check table by using (in the valid if)

Select(
Apparatus Inventory Items[Equipment Description],
AND(
([Subcategory] = "Fitting"),
([VIN] = [_Thisrow].[Vin]),
([Apparatus Compartment] = "Bumper Compartment 1",
)
))

This goal is to display what the inventory table says should be there. What i want to do now  is say if all Items are there (selected) then True, else false. 

Is this possible within the column itself? If not and a new column is needed, what expression is needed to say all enumlist items have been selected? I cannot give it a list to check because of the dynamic nature of the inventory table changing/updating items

[Aurelien · Accepted solution]

Hi @Shock 

So you expression should be:

ISBLANK(

SELECT(
Apparatus Inventory Items[Equipment Description],
AND(
[Subcategory] = "Fitting",
[VIN] = [_Thisrow].[Vin],
[Apparatus Compartment] = "Bumper Compartment 1"
)
) -SPLIT([Fittings Check],",")

)