Forum Discussion
Solved
Creating Roles & Managing
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
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
3 Replies
Replies have been turned off for this discussion
- Hi Michael you need to create a hierarchy as described here: http://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
- 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
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
