Forum Discussion
Solved
Problems with using more than one relationship
Hi, I am currently struggeling to solve one issue. In my data model I have various tables with active and inactive relationsships. In this case its about the following three tables: ...
You should be able to turn off the link between Workbench - Calender using CROSSFILTER and setting the direction to NONE. You would add this along with your USERELATIONSHIP which turns on the Calender - Work Order Time Transaction relationship.
https://docs.microsoft.com/en-us/dax/crossfilter-function
jdbuchanan71 sorry for my late reply and thanks for your help. I also noticed that in contrast to my initial thought my connection between the Work Order Time Transaction and Calender were not mapped correctly. I changed that and using the CROSSFILTER, I finally get the results that I needed.
Best regards
Hanssonnor