topic How to show a total regardless the user that is connected in DAX Commands and Tips

How to show a total regardless the user that is connected

charrynsasi — Tue, 21 Jan 2025 13:37:22 GMT

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,

Re: How to show a total regardless the user that is connected

johnt75 — Tue, 21 Jan 2025 13:52:16 GMT

Have a look at https://www.sqlbi.com/articles/computing-accurate-percentages-with-row-level-security-in-power-bi/

Re: How to show a total regardless the user that is connected

bhanu_gautam — Tue, 21 Jan 2025 13:54:50 GMT

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)
)

Re: How to show a total regardless the user that is connected

johnt75 — Tue, 21 Jan 2025 14:13:28 GMT

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.

Re: How to show a total regardless the user that is connected

bhanu_gautam — Tue, 21 Jan 2025 14:23:59 GMT

johnt75 , Right it will show total only when RLS is not placed

Re: How to show a total regardless the user that is connected

charrynsasi — Tue, 21 Jan 2025 14:27:39 GMT

Thank you johnt75