Conditional format parent table based on child status values

[Nickb800000]

Hi There

I was hoping for some help. I'm trying to do a conditional format so that when all the related items in my child table reach a status "parts for assembly" that it changes the parent table. I've tired doing this with count and select function but without much luck I just wondered if anyone had any insights to this?

Thanks

[lynchk21 · Accepted solution]

Try:

COUNT([_thisRow].[Related Child Tables])=COUNT(SELECT(Child Table[Key Column],AND([Parent Reference Column]=[_thisRow].[Parent Key Column],[Staus]="parts for assembly")))

[Nickb800000]

thank you so much that works perfectly