Setting RLS for specific dealer, but want to show nationwide data without RLS to all dealers

[santatis]

i already set RLS for specific dealer, and it already works!

However, i want to show the percentage of nationwide and region data without RLS to all dealers too. 

what should i do?

[Kedar_Pande · Accepted solution]

@santatis 

create measures that ignore RLS filters using the REMOVEFILTERS function. For example:

NationwidePercentage = 
DIVIDE(
SUM('Sales'[Amount]),
CALCULATE(SUM('Sales'[Amount]), REMOVEFILTERS('Dealers')),
0
)

RegionPercentage = 
DIVIDE(
SUM('Sales'[Amount]),
CALCULATE(SUM('Sales'[Amount]), REMOVEFILTERS('Dealers'), 'Regions'[Region]),
0
)

💡 If this helped, please give Kudos 👍 or mark it as a Solution ✅.
Best regards,
Kedar
🌐 Connect on LinkedIn