Row level security control by page

[Daisuke]

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

[Daisuke]

@ribisht17 
thanks. I could solve!

[ribisht17 · Accepted solution]

@Daisuke 

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