How to setup RLS to treat Assistant managers as mangers for only a single visual?

[balaganeshmohan]

I have a dataset setup and running which works with the logic filtering based on position.

1. AM's can see data that are related to their id.

2. M can see data related to their id and the rest of the country.

I have a unique request where in a single visual, all the AM's should be able to see their colleagues data, which is esentially a view M would have but only for that visual. Is this even possible?

These are my dax expression for filtering,

And my models looks like this, I filter customer to filter out the rest of my data in whole PBI.

[v-jingzhang]

Hi @balaganeshmohan 

Since you want only a single visual to be different from the current RLS, a possible solution is to create a calculated table that includes aggregated values to populate that specific visual. Keep this table disconnected from other tables in your current model. Only select columns from this table into that visual. And create a RLS DAX expression on this table to look up Country rather than Person code, similar to the second DAX expression shown in your Post. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

[balaganeshmohan]

@v-jingzhangThanks, that sounds like it would work, but what about in the long run when more of these requests comes in, making a copy of large tables in a large dataset doesn't seem very effecient.