Remove RLS affect on a Specific Measure

[AramKuru]

Dear All
I created a dashboard that compares city-based data to the country
I created RLS for each city so each city can only see their data
but the problem is when RLS is applied it will apply to country data too so what should i do to prevent RLS affect one specific measure?

[v-xiaoyan-msft]

Hi @AramKuru ,

Are you referring to the fact that your RLS rules set the user to see only a specific city, but the actual content not only shows the specific city but also its corresponding region/country? It‘s by desgin.

You can't use RLS to limit the columns or measures accessible by your users.
if a user has access to a particular row of data, they can see all the columns of data for that row.

Best regards.
Community Support Team_ Caitlyn