Table Relationship

Hello

I tested the solution proposed by Segei and noticed that the performance is not that good

so finally I chose the solution to have two tables linked and put the possible roles.

now I hav another issue

im my table Roles, I have two colums

Colum 1 : Roles ( containgna ll possibe rules

Column 2 : Type of P&l tswo possible values either entity or destination

in my Table 2 : Raw_Data

I have different column : role, orders, country, ...

I would like to use a measure that takes into consideration only the roles where the P&L is entity

the system is giving me an error.

I used ralated and if 

Entity orders :=CALCULATE(Raw_Data[Sum of Orders] ;

FILTER(Raw_Data;  RELATED(FSA_Role[P&L]="Entity")))

can you please support

regards