Forum Discussion
Relationships Assist
Hello I've been having a difficult time with managing the relationships of one of my builds.
You see, I have two data sets.
Data Set 1: - A list of employees and their BU Leader
Data Set 2: - A list of employees and action plans they've entered into a system
Data sets 1 & 2 are linked based on the employee name value.
I created a table to capture # of teams within a BU Leader in another table
This table is linked to Data Set 1, based on the BU Leader Value
The problem I'm running into is, when I try to visualize # of action plans by BU Leader, my visual is not working. 😞
Here's a link to the .pbix file.
The visual I'm trying to produce is titiled action plans entered by Leaders vs. Expected. Everything is set from a data perspective on how I want this to work. I believe it might be a relationship issue. Could you take a look and let mek now what you've found/teach back please?
Thanks Much, Naberius
Hi Anonymous
i have no permission to edit your data model in file and i dont completely undertand what is issue, so i can not check, but..
I see a lot of many-to-many relationships by [Employee Name] field.
I could recommend to create a bridge dimEmployee table which will contains of unique [Employee Name] values.
then create relationships like
BUL Action Plans - Business UnitDetails AS IS
Business UnitDetails - dimEmployee
dimEmployee-Action Plans by Employee
dimEmployee-Action Plans LT
dimEmployee-Action Plans by Q
1 Reply
- az38Community Champion
Hi Anonymous
i have no permission to edit your data model in file and i dont completely undertand what is issue, so i can not check, but..
I see a lot of many-to-many relationships by [Employee Name] field.
I could recommend to create a bridge dimEmployee table which will contains of unique [Employee Name] values.
then create relationships like
BUL Action Plans - Business UnitDetails AS IS
Business UnitDetails - dimEmployee
dimEmployee-Action Plans by Employee
dimEmployee-Action Plans LT
dimEmployee-Action Plans by Q