Create Alias with RLS

[Anonymous]

Hello everyone,

Let's say I am having three tables as below:

When I used RLS username = username(), the result is the table with the org belongs to user login only. For example, when the user albert@abc.com login, the data is org one and two only.

However, I need to have the result that shows all orgs, but with org three and four, it shows the alias instead. The result should be like this:

It means for the organizations that not belongs to this user, I just show the alias.

Can we do this?

Thank you very much

[v-chuncz-msft]

@Anonymous,

You need to create a measure instead of RLS.

[Anonymous]

@v-chuncz-msft

Can you give a sample measure? I don't know how it works