How to implement RLS without useremail stored

[Anonymous]

I have a CountryVirtual table like below:

Role	VID
US	1
UK	2
GR	3

Fact table VIRTUALS

VID	VNAME
1	a
1	b
2	a
3	d
3	e

Note that I do not have VID mapping to useremail anywhere.

Now, for me to implement RLS where I create 3 roles like US, UK, GR with hardcoded filter on CountryVirtual table.

The filters are VID = "1" for US, VID = "2" for UK and so on.

It all works fine. 

But question is on how I can avoid this hardcoded filters?

• There will be future countries added and the CountryVirtual table is updated in the backend.

Can I write a DAX formula to the right of VID = expression? If so, what can it be?

[amitchandak · Accepted solution]

@Anonymous , If you do not have email mapping, you have to create roles by value and assign them to users. So my advice would be to create one

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk