Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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>

UserRegion
AEast
BWest
CCentral

 

<Sales Table>

RegionSales
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.
    RegionSales
    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.
    RegionSales
    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

  • 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