Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

  • az38's avatar
    az38
    Community 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