ignore RLS for a aggregated measure

HI 

I HAVE A PBIX FILE I CAN SEND TO YOU IF YOU WANT A TEMPLATE 

I have a aggreate  sum measure that dosent work as entented after i apply RLS

Sales amount= sum(sales)

before RLS is applied

1) the company is chossen in "Company"

2) the employee is chossen in the table "Employee". In this case Frederik. 

3) an employee has different "sales" in different companies. see in the “sales by company”

4) the “sales by company” has no interaction to the company visual (made in format -> edit interaction)

After RLS is applied
Now we have a problem in the “sales by company” when I have chosen Frederik in “sales by employee”

When I chose an employee the sales amount only show the value for one company even tough that Frederik has sales in other companies.

the data model

The RLS applied

SEARCH(","&LEFT(USERPRINCIPALNAME(),(FIND("@",USERPRINCIPALNAME(),1)-1))&",", [User] , 1, 0) > 0

the problem:

i cant add "TEST" to multiple companies in the user because TEST can only view for specific company in the report EXCEPT the “sales by company” then they need to see all the companies that an emplyee has sales.

The goal:

Get the same output as in the first picture AFTER i apply RLS and i chose an employee i have to see all sales for each company.

possible solutions:

writa a measure that over write the RLS. 

write a more complex RLS code