Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Area | Country | Territory | Profit |
APAC | Taiwan | North Territory | 328376.4 |
APAC | Turkey | South Territory | 933903.8 |
China | China | East Territory | 4509794 |
SAM | Argentina | West Territory | 59960.32 |
SAM | Mexico | North Territory | 1187679 |
EMMA | Saudi Arabia | South Territory | 202941.7 |
APAC | Taiwan | West Territory | 287316.9 |
APAC | Turkey | North Territory | 477944 |
China | China | South Territory | 162892 |
SAM | Argentina | East Territory | 2280701 |
SAM | Mexico | West Territory | 363198 |
EMMA | Saudi Arabia | North Territory | 26185.28 |
APAC | Thailand | South Territory | 2093016 |
APAC | Turkey | West Territory | 15549.03 |
China | China | North Territory | 2334947 |
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.
Solved! Go to Solution.
@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.
Proud to be a 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.
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |