Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
MichaelG_NAC
Frequent Visitor

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
1 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"

3.PNG4.PNG 

 

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])

1.PNG2.PNG 

 

Regards,

Jimmy Tao

View solution in original post

3 REPLIES 3
LivioLanzo
Solution Sage
Solution Sage

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

 


 


Did I answer your question correctly? Mark my answer as a solution!


Proud to be a Datanaut!  

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

@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"

3.PNG4.PNG 

 

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])

1.PNG2.PNG 

 

Regards,

Jimmy Tao

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.