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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
ryan_b_fiting
Post Patron
Post Patron

Role Playing Dimensional Slicer Table

Hello Community 

I am trying to create a Role Playing table that allows me to slice my reports with a role from that table.  My data sets originally were a fact table, employee table and date table. 

 

My fact table has 2 columns with employee id's, one for employee assigned to the claim and one with the employee assigned to the exposure.  Because of this, I created a Claim Emp table (all employees with role 'Claims' added) and an Exp Emp Table (all employees with role 'Exp' added). 

 

I do not want to use USERELATIONSHIPif possible because there are a lot of metrics we are looking at. 

 

From the Claim Emp Table and Exp Emp Table, I have appended those table into a Role table.  It shows all employees for each Role.  What I want to do is be able to select the role from this table and use it as a slicer to be able to slice the data by the different roles.  Here is sample data:

FACT TABLE

IDCountExpIDClmIDROWwid
14512312310
25612913911
323415515812
457612318313
52312515515

 

CLAIM EMP TABLE

Row IDEmp NameRoleZone
123AClaimNorth
139BClaimSouth
158CClaimSouth
183DClaimWest
166EClaimEast
129FClaimEast
155GClaimWest
125HClaimNoth

 

EXP EMP TABLE

Row IDEmp NameRoleZone
123AExpNorth
129FExpEast
155GExpEast
125HExpNoth
139BExpSouth
158CExpSouth
183DExpWest
166EExpEast

 

ROLE TABLE

Row IDEmp NameRoleZone
123AExpNorth
129FExpEast
155GExpEast
125HExpNoth
139BExpSouth
158CExpSouth
183DExpWest
166EExpEast
123AClaimNorth
139BClaimSouth
158CClaimSouth
183DClaimWest
166EClaimEast
129FClaimEast
155GClaimWest
125HClaimNoth

 

Is there anyway to model this data so that I can select the role, and it will filter the fact data based on the emp id role columns from the fact table?(ExpID and ClmID)

I am not sure that this is possible, but wanted to reach out to the community.


Thanks

Ryan

1 ACCEPTED SOLUTION
2 REPLIES 2

This does not really solve the issue, but I believe it confirms what I thought and that the full solution my client is looking for is not actually possible.

Thank you for the information.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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