row restriction based on column value based on the login

[Anonymous]

Hi,

I would like to restrict the row from the visual based on the column value.

Consider a table with 3 columns namely: Customer Name, Bed Size and Invoice Amount.

Sample dataset

Here When I login as a Customer A then I would be able to view Customers with Similar bed size. (Similar points to +/- 20% of bed size of the logged in Customer, In this case +/- 20% of Customer A)

The required output is 

Required Output

Since the Customer C's bed size is 100 which is more than 20%.

Thanks

[v-juanli-msft]

Hi @Anonymous 

As tested, parry2k's solution would be helpful.

Besides, you could refer to the documents how to create RLS in Power BI.

Row-level security (RLS) with Power BI

If user uses email address to log in Power BI, then you could create a User table including user names and email address,

Then create a relationship with main table.

For more details, please refer to the "Dynamic RLS" part of the following article.

https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[parry2k · Accepted solution]

@Anonymous add followig DAX expression for RLS. Change  Table and Column name as per your data model.

Add following measure

Max Size = MAX ( 'RLS Rate'[Size] )

Add expression for role

modelling -> manage roles -> create -> enter role name -> select your table and paste following code.

VAR __user = USERNAME()
VAR __bedSize = 
CALCULATE ( 
    [Max Size],
    ALL ( 'RLS Rate' ),
    'RLS Rate'[Name] = __user
)
VAR __upperRange = __bedSize * 1.20
VAR __lowerRange = __bedSize * 0.80
VAR __rls =
IF ( 
[Max Size] >= __lowerRange && 
[Max Size] <= __upperRange , 
TRUE(), FALSE()
) 
RETURN __rls 

[Anonymous]

Thanks parry2k