'How to make SSAS row level security ignore table relationship?

In SSAS tabular model I have two tables with one to many relationship

Table_A
  A_Id,
  Code

Table_B
  B_Id,
  Name,
  A_Id

To achieve RLS, I created a new role with a filter on Table_A

= [Code] = "US"

The problem is I only want to filter Table_A by code, but it turns out the related data in Table_B is also being filtered.

Question: how to ignore the relationship in RLS?

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Solution	Source