When creating a table object in DAX, the code is evaluated and run each time there is a change to the data model. Filters interactions do not impact the table, and therefore you should use a measure instead of a table.

From your example, you should activate the one to many relationship between users and brands, and that should filter the list of users you are looking for.