Extra Column based on status in group

Hi,

I have the table "Objects"   in power bi with the following columns:

Now i want to create a custom column named "Ticket" with yes or no based on the status of a Number of a specific subgroup.

The result would be like this, so each number in each subgroup can only have one entry in the ticket column based on the status of the Number:

1) Every subcategory should have one or more entries in the ticket column.

2) If there are only numbers in the subcategory with the status "Closed" or "Completed" there should only be 1 entry in the ticket column

3) If there are numbers in the subcategory with status other then "Closed" or "Completed" there should be one entry for each other status (other then "Closed" or "Completed")  in the ticket column

so:

if subgroup = "Annx 1" and status of any number in that subgroup is only "Closed" or "Completed" --> 1 entry in total for that subgroup in ticket column
if subgroup = "Annx 1" and status of any number in that subgroup is other then "Closed" or "Completed" --> 1 entry for each number in that subgroup that has status other then "Closed" or "Completed" in ticket column

How can I do this?

sample file: https://1drv.ms/u/s!Aos-gKWrjzqNb0QSKQZBb71oJBg?e=57KbQd