Security Role - Show all data rows but no data in column of other rows

[thhmez7]

Hello,

In this example, when User A is logged in later in PBI Service, he should still see all data rows from other users. But he should not see any data (Blank) of the column "Checked". So User A sees:

A1; Yes

A2; Blank
A3; Blank

A4; Blank

A simple Userprincipalname in a RLS would not work, because User A would only see his data row.

How can I achieve this by Manage roles or creating new column? 

Thank you.

[thhmez7]

Hi, 

thank you a lot. Now it works. I forgot to mark the security filter in the relation of Account and User table.

[amitchandak · Accepted solution]

@thhmez7 ,

a new measure =

var _1  = countrows(filter(Table, Table[User]) =  userprincipalname() )) +0

return

if(_1>0 , "Yes", "" )

[thhmez7]

Hi  @amitchandak 

I tried your measure and entered the domain of User A in "View As". However it seems that User A sees "Yes" for User B as well now, that would be wrong.

[Anonymous]

HI @thhmez7,

Can you please share a pbix or some dummy data that keep raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng