Forum Discussion
Data Modeling (Relationship issue)
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
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.
Hello Brent_LaCorte
Is this fine now
The .pbix file is given below for your quick reference.
https://drive.google.com/file/d/16UHr3-dPrMM21woHpHiZjg0F81m6qxTx/view?usp=sharing
I hope this helps.
Regards
Kumail Raza
Good morning Kumail
I appreciate the quick response! This would absolutely normally work. However, the data sets that I am working with normally don't have the Supervisor attached to them. It's normally just the associate and the shop.
Hello Brent_LaCorte
Its the calculated column added to the data table to get the Associate and Shop relationship working in the model.
In the original data, you can also add this column in using the following dax function and create an inactive relationship, in the data model.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and I would love to see your like.
Regards
Kumail Raza