Total value of Measure does not work with RLS

[thhmez7]

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.

[Greg_Deckler · Accepted solution]

This looks like a measure totals problem. Very common. See my post about it here: https://community.powerbi.com/t5/DAX-Commands-and-Tips/Dealing-with-Measure-Totals/td-p/63376

Also, this Quick Measure, Measure Totals, The Final Word should get you what you need:
https://community.powerbi.com/t5/Quick-Measures-Gallery/Measure-Totals-The-Final-Word/m-p/547907

[thhmez7]

@Greg_Deckler 

Thanks a lot for the great overview in the Quick measure gallery. Your measure works well in my report with Summarizing the Count of Activities.

How does the measure look with percentage measure if I want the average of all percentages by User?

Thanks in advance!