Forum Discussion

ClaudeV's avatar
ClaudeV
Regular Visitor
4 years ago
Solved

RLS and Calculate

Hi guys,   I need some help with RLS and Calculate.   My data is setup as the following: Each Location connected to a email address and each location within a Province   I have created a RLS f...
General Comment
Tips and Tricks
  • DataInsights's avatar
    DataInsights
    4 years ago

    ClaudeV,

     

    Here are two solutions you can try. Each solution uses the following measure and RLS filter for DimLocation:

     

    Province Net Sales = SUM ( 'Sum of Totals'[Net Sales] )

     

     

    Solution 1

     

    Create a many-to-many relationship between DimLocation and Sum of Totals. DimLocation should filter Sum of Totals.

     

     

    Solution 2

     

    There is no relationship between DimLocation and Sum of Totals. Add an RLS filter to Sum of Totals:

     

     

    [Province] IN
CALCULATETABLE (
  VALUES ( DimLocation[Province] ),
  DimLocation[Email] = USERPRINCIPALNAME()
)

     

ClaudeV's avatar
ClaudeV
Regular Visitor
4 years ago

DataInsights thank you.  Solution 2 worked.  I had to use solution 2 as I created relationships between the locations and that mad a mess of everything