Intersect count with filters

Hello lbendlin I tried to explain this as well as i could: Table 2 has the linked(Link) information for every ArtID from Table 1, for example for ArtID 1 has one to many relationship with Table 2 where will find information for the links that ArtID 1 is having, so the Link refers to the UnID back to Table 1. That means ArtID 1 has links with O-12 and O-15 which back into Table 1 is ArtID 2 and ArtID 5. The other columns like "STR" only flags what kind of "ArtID" we're dealing with. I have no idea what information should i provide. I know this might be unclear but i explain it in details or maybe you can tell me what exactly is unclear. 

This would be a simplfied version of the Measures i need:
Measure 1: Number of "STR" that have links with one or many EER or SYS = 1 (ArtID 1 has link with an EER or SYS) + 0 (ArtID3 has no link with an EER or SYS) + 1 (ArtID 6 has  one link  with EER or SYS) + 1 (ArtID 8 has link with an EER or SYS)
Measure 2: 
Number of "STR" with implementation in {"implemented"} OR all in-linked "EER" and "SYS" with implementation in {"implemented"}: 1 (ArtID 1 has "implemnted") + 0 ( ArtID 3 "str" with not_implemented and all links are in not_implemented) + 0 (Art 6 "str" with not_implemented and not all links with in implemented, only O-12 is implemented) + 1 (Art 8 "str" not_implemented but all links are in implemented, O-15 and O-12) = 2. Hope it helps. Thanks