Hello @yingkz, there is a lot going on here so I will try to provide you with the solution that I think is most likely to work for this scenario.
I’d recommend adding parameters for all of the values that you want to filter the other visual by. Then build a navigation action and have it set those parameters based on the fields that you want to determine the filters. Then it can navigate you to the sheet with the table you are wanting to filter (that can include the same sheet), and make sure that table is filtered by the parameters.
I actually have a video that shows how to set parameter values with navigation actions to help!
Let me know if this helps guide you to the solution you are expecting!