Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to 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
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
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |