Forum Discussion
Row level security control by page
Repost: Since I think my previous post may confuse
Question: Is it possible to set row level security control by page?
Here is example
<User Table>
| User | Region |
| A | East |
| B | West |
| C | Central |
<Sales Table>
| Region | Sales |
| East | $100 |
| West | $200 |
| Central | $300 |
There are 2 pages "Country" and "Region"
- When user goes to "Country" page, total number of sales, $600, is shown with the following table.
Region Sales East $100 West $200 Central $300 Total $600 - When user goes to "Region" page, only regional data is shown. For instance, if user A access to the page, $100 is shown.
Region Sales East $100
I would appreciate for your support
Anonymous
You can make use of USERNAME function (DAX) - DAX | Microsoft Docs on the Region page only
Suppose you have a Security Table
Security
UserName | Region |
A |East
B | West
C | South
Join above with your dataset
Then
Condition
User Name=username() && [Security]Region= Region
[Table]
Ritesh
2 Replies
- ribisht17Super User
Anonymous
You can make use of USERNAME function (DAX) - DAX | Microsoft Docs on the Region page only
Suppose you have a Security Table
Security
UserName | Region |
A |East
B | West
C | South
Join above with your dataset
Then
Condition
User Name=username() && [Security]Region= Region
[Table]
Ritesh
- AnonymousNot applicable
ribisht17
thanks. I could solve!