cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
k3rz0rg
Advocate III
Advocate III

DRLS with some visuals with all data!

Hi everyone,

 

as I was working with DRLS recently, I came across a situation where I may need to show a global/grand/all total to everyone while DRLS is active. I already have DRLS active and it's filtering the data good, for example, USA people can only see sales total count in USA through card visual, Germany people can only see German sales total through that Card visual.

Now I want to show both parties the total/global/all count of employees irrespective of DRLS/region (region is the DRLS filter I set). Is it possible and if so, could you please show me/ refer the procedure?

Right now, due to RLS, USA people can see USA total employee count and same for the Germany.

 

Thanks,

K3.

2 REPLIES 2
jdbuchanan71
Super User
Super User

@k3rz0rg Measure can't override RLS because, as far as the measure knows, the rows of data that are filtered out don't even exist.  You would need to put the total amount you want to show everyone in a seperate table and adjust your count measure to pull from that total table when diaplaying the total row.  It will be something like:

Count =
IF (
    ISINSCOPE ( 'YourTable'[Region] ),
    [Emlployee Count Measure],
    SUM ( 'Total Table'[Employee Count] )
)

 

I also thought so, thinking I am doing dataset level restriction by users with DRLS, not visual or report level restrictions, your statement solidifies that and I can explain more to my big guys why's not possible this way! Let me try your way, creating another table and have it bypassed the DRLS and see if that worked! I'll keep you posted! 

Thanks!

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors