Forum Discussion
Data Modeling (Relationship issue)
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
Kumail I apologize, there are a lot of things I am trying to solve with this one fix and I thought I brought them all up but I just noticed something else.
When filtering by Supervisor with the related function, it does indeed only show the results where they are the assigned supervisor but it also shows associates who are not on their team. In this instance Craig's results show transactions from Bill's team as well. I am trying to keep everything isolated to only showing results where that specific supervisior team had an impact. I am trying to make this go vertical as well, meaning Manager, Director, Region (if need be). I hope that made sense.