Forum Discussion

Brent_LaCorte's avatar
Brent_LaCorte
New Member
5 years ago

Data Modeling (Relationship issue)

I have a data set that I am trying to filter a specific way and am unable to figure out how to set up the relationships to make it work. In this example I have 3 tables.    The data table Trans...
Need Help
Brent_LaCorte's avatar
Brent_LaCorte
New Member
5 years ago

Hey there Kumail,

 

I have created a sample file but I for the life of me can't figure out how to attach it to this  post.

Kumail's avatar
Kumail
Impactful Individual
5 years ago

Hello Brent_LaCorte 

 

You can add the file to your drive and add the url to drive here.

 

I hope it helps.

 

Regards

Kumail Raza

  • Brent_LaCorte's avatar
    Brent_LaCorte
    New Member
    5 years ago

    Kumail 

     

    Let's see if this works for you. 

     

    https://www.dropbox.com/s/rw14hfivxybtosw/Example.pbix?dl=0 

     

    This is a very basic example of what I am working with. I can't upload the actual file due to privacy issues. I am also creating this in Excel through Power Pivot but it is essentially the same thing in Power BI. 

     

    As you can see in the example when you click on Bill's shops that he is assigned to it shows ALL the shops where the associate had a transaction, including Craig's. I am looking to only show the values for the shops that are assigned to each supervisor. Again, this is very basic. The problem is excaberated with the larger dataset as there are 150+ shops split between 8 or so supervisors.