Forum Discussion

k3rz0rg's avatar
k3rz0rg
Advocate III
5 years ago

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.

Need Help
Tips and Tricks
Tutorial Requests

2 Replies

  • jdbuchanan71's avatar
    jdbuchanan71
    Super User
    5 years ago

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

     

    • k3rz0rg's avatar
      k3rz0rg
      Advocate III
      5 years ago

      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!