Dynamic Row Level Security with custom column values

[Keerthanagowsi]

Hi,

I have to apply dynamic RLS at country and city level in one of my dashboards. All the details are fed through a table. I have checked for applying dynamic RLS in web and found that through DAX expression, we can achieve it. But the thing is that the input of my access table will be in the following format.

Email	City	Country
emailid1	Chennai	India
emailid2	ALL	ALL
emailid3	ALL	ALL

And in my source table i won't be having "ALL" in the City, Country fields. Can any of you help me in solving this?

Thanks much in advance.

[parry2k]

@Keerthanagowsi check these two videos on my channel and see if it helps:

How to set up conditional Row Level Security - RLS pattern in Power BI - YouTube

Learn basics of Row Level Security (RLS) - How ALL function is used for the solution? - YouTube

[Keerthanagowsi]

Hi @parry2k 

Thanks for the videos. But my problem is different. If the city/country columns of my access input table is ALL, then the user should be able to access all the country and city data.

And my source table will not have a data called ALL in the city/country columns.

Is there a way to apply RLS, that if the access input table have an entry as ALL in city or country, then user should access all the data, else if the column have specific city/country that should be shown for the user?