Creating Roles & Managing

[MichaelG_NAC]

Hello I am looking into creating 4 roles. 3 which can only access certain information and 1 which can access everything. e.g Role 1 = [Name] = "A" Role 2 = [Name] = "B" Role 3 = [Name] = "C" But I am having issues trying to create the last one which can access everything, is there coding to allow for this or would it simply just be Role 4 = [Name] = "A" + "B" + "C" Thank you

[LivioLanzo]

Hi Michael you need to create a hierarchy as described here: http://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi

[MichaelG_NAC]

Hello I may have not represented it correctly The idea is that the Column [Name] is what I'm filtering for the roles Role 1 will only see the information that is from "A" Role 2 will only see the information that is from "B" But I want Role 4 to see the information from all of them so information from A, B and C i.e Name Number A 2 B 4 C 6 So if I summed Number the roles would see Role 1 - 2 Role 2 - 4 Role 3 - 6 Role 4 - 12

[v-yuta-msft · Accepted solution]

@MichaelG_NAC,

Click Modeling-> Manage Roles and create 4 roles using DAX below:

Role1: Table1[Role] = "A"

Role2: Table1[Role] = "B"

Role3: Table1[Role] = "C"

Role4: Table1[Role] = "A" || Table1[Role] = "B" || Table1[Role] = "C"

 

Create a measure and drag Role and measure to a chart, when you want to apply roles, click view as roles:

Total = SUM(Table1[Number])

 

Regards,

Jimmy Tao