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

     

DataInsights's avatar
DataInsights
Super User
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()
)