Show all table data/ corresponding data depending on the condition

[Hitesh_c]

Hi 
I am trying to implement rls on a power bi report 

i have a table which has 1000's of id's, i want to show the entire table if the custom data is passed as string 'All' and show only data corresponding to that id if the custom data is passed as 'id'

looking for an equivalent of 

[id] = if('Table'[Custom Data] ="All", {missing code to show data for all id's}, 'Table'[id])

this table already has a relationship with another user table which filters data to show relevant information for logged in user only

also open to trying out any other approach instead of adding this filter to the role

[Daniel_PowerBI]

Hi,

You can try dynamic RLS with USERPRINCIPALNAME() which is based on the email connected to Power BI Services

Here is a nice video explaining how to do it:

https://www.youtube.com/watch?v=axTyP7I2Bso

[Hitesh_c]

Hey Daniel,

Thank you for your reply, i've been able to setup RLS using principal name, the requirement here is that the report will be placed in 2 different locations 

One would be a general dashboard where users would be able to see project id's assigned to them 

this view would contain certain WBS data along with the project id's 

Second would be inside the project id's where it should only show data relevant to that project id.

So depending on where the report is being called from in the UI we want to showcase all data or some data 

when i'm implementing RLS 

i'm able to obtain filtered data using the highlighted part
it is that when the same report is pulled from where it show all data the italic part i'm facing issues with the syntax or logic implementation 
 
[id] = if('Table'[Custom Data] ="All", {missing code to show data for all id's}, 'Table'[id])

i've tried to use [id] = [id] standalone and that works but not in IF statement