Change status of virtual column when record are added on child table

[areyes]

Appreacite your help to figure out this. I need to create an expression so that when at least a record is created either on the device table or in the Materials table,  a virtual column in the Task (parent table) gives a message. 

I am trying this expression, but is always returning false even though there a records in the child table: 

IF(
OR(
COUNT(SELECT(Dispositivos[HARDWARE ID], [HARDWARE ID] = [_THISROW].[id])) > 0,
COUNT(SELECT(Materiales[MATERIAL ID], [MATERIAL ID] = [_THISROW].[id])) > 0
),
"Please Check",
"Nothing to check"
)

[AleksiAlkio · Accepted solution]

I assume they are both child tables for the Task, then use something like..

IF(COUNT([Related Devices])+COUNT([Related Materials])>0,..)

[areyes]

Thank you so much! It worked.

[AleksiAlkio]

You're welcome!