cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Shreeram04
Resolver I
Resolver I

Row Level Security

Hi All,

 

I need to achieve dynamic row-level security for the area, country, and territory columns. I can do it for both area and country but I am unable to find the solution for territory.

 

1. When I enter Apac level means it shows value APC area values only.

2. when my country is china means its shows china's country values only.

3. And if I enter as south territory for china means its shows value for south territory for china only.

 

Sample data:

 

AreaCountryTerritoryProfit
APACTaiwanNorth Territory328376.4
APACTurkeySouth Territory933903.8
ChinaChinaEast Territory4509794
SAMArgentinaWest Territory59960.32
SAM MexicoNorth Territory1187679
EMMASaudi ArabiaSouth Territory202941.7
APACTaiwanWest Territory287316.9
APACTurkeyNorth Territory477944
ChinaChinaSouth Territory162892
SAMArgentinaEast Territory2280701
SAM MexicoWest Territory363198
EMMASaudi ArabiaNorth Territory26185.28
APACThailandSouth Territory2093016
APACTurkeyWest Territory15549.03
ChinaChinaNorth Territory2334947

 

when I did for territory means its shows dates like south territory for all areas and countries but my requirement is its show value for particular country-based territory. Please help to identify the solution, thanks in advance.

1 ACCEPTED SOLUTION
negi007
Super User
Super User

@Shreeram04 i would suggest you to create a calc column in your table based on country and territory and then apply RLS on that column.

Your new column could be like 

country_territoy = tab[Country] & "|" & Tab[territory]

 

 

in that way it filter correctly. In your current situation, you have noth, west, south and east territory in many countires. 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


View solution in original post

1 REPLY 1
negi007
Super User
Super User

@Shreeram04 i would suggest you to create a calc column in your table based on country and territory and then apply RLS on that column.

Your new column could be like 

country_territoy = tab[Country] & "|" & Tab[territory]

 

 

in that way it filter correctly. In your current situation, you have noth, west, south and east territory in many countires. 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos


Proud to be a Super User!

Follow me here


Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

Ted's Dev Camp - October 6, 2022

Watch the playback of Session 26 with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors