Total value of Measure does not work with RLS

Hi,

I have measure which counts of Activities by User in table.

It works without the created Row-level security.

The role, that I created, is a CRM security role with multiple User hierarchy levels.

This is how I created in "Manage Roles":

PATHCONTAINS(Systemusers[Path],
LOOKUPVALUE(Systemusers[systemuserid],
Systemusers[domainname],USERPRINCIPALNAME()))=True

After testing the role in Power BI Desktop, the table doesn't show the correct total value. Or maybe the values in the rows aren't correct.

The measure "Activities" sums the Count-Field from different tables:

Activities= CALCULATE(SUM('Task'[Count])) + CALCULATE(SUM('Notes'[Count ])) + CALCULATE(SUM('Projects'[Count ])) + CALCULATE(SUM('Activities'[Count]))

 

Also, I wanted to apply security filter in both directions between the tables Systemuser and Activitytable (where the measure was created), but it didn't work:

Thanks for your help!

Kind regards.