is It possible to be able to choose if being affected by a role or not?

[Ricardofaster]

Hi, We want to know if IT is possible to see in the same report, two visuals, one affected by an active role (RLS) and the other one with all data. This is needed for multiple tables (our model has around 40 tables) and multiple sheets. Nowadays is a slow model.

I appreciate any advice.

All the best.

[amitchandak]

@Ricardofaster , depend on how RLS is implemented.

refer if these can help

https://community.powerbi.com/t5/Desktop/DAX-Code-for-Dynamic-RLS/m-p/807960

https://forum.enterprisedna.co/t/dax-to-ignore-row-level-security/805

[Greg_Deckler · Accepted solution]

@Ricardofaster - In general no, you would need duplicate tables or summary tables that are not tied to any RLS rules.