Forum Discussion
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...
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