How do I change data for multiple reference rows from a row in another table?

[Andrew_Hock]

I’m stuck on trying to change data on one table based on changes from another. For example, I want to make a row in the Filters table become Inactive based on when a row in a reference row (Properties) becomes Inactive. I created an Action Data: execute an action a set of rows with the formula: SELECT(Filters[Property ID], [Property ID] = [_THISROW].[Property ID]), but it doesn’t work correctly.

Also, there can be multiple Filters referenced to a single Property. And I want all of them to be inactive when the Property becomes inactive.

Any suggestions are helpful.