Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hello community,
Hope you're doing right.
I want to show the total of student even though i use RLS to filter data based on the user that is connected using USERPRINCIPALNAME DAX command.
Total student = CALCULATE(
DISTINCTCOUNT ( Student[ID] ),
ALL(Student),
Student[Level]=6)
The director of X school is able to see the total of these students but i want him to see as well the total of all student of all schools.
Is there away to do so ?
Regards,
Solved! Go to Solution.
@charrynsasi To show the total number of students regardless of the user that is connected, you can modify your DAX formula to ignore the row-level security (RLS) filters.
Total student = CALCULATE(
DISTINCTCOUNT(Student[ID]),
ALL(Student)
)
Proud to be a Super User! |
|
@bhanu_gautam this is incorrect. You cannot use DAX to bypass RLS. ALL will remove filters, but it will not remove the restrictions placed by RLS. Any rows removed by RLS filters will not be visible at all, no matter what you do to the filter context.
@johnt75 , Right it will show total only when RLS is not placed
Proud to be a Super User! |
|
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
26 | |
24 | |
12 | |
11 | |
10 |