Forum Discussion
Relationship direction keeps changing itself
Hi Anonymous ,
The Related wotrks from the many to one side so in you case you are making the formula incorrectly. Let's break down the calculation you need.
You want all the Jobs that exist for a contact correct.
If you pick up you contact first you get a single value and then you try on the line to place all the related lines of Job this is not possible because you are getting a multiple value for each line so the result is an error.
If you do the other way around starting from the Jobs you are getting for each line of the job a single line of the Contact so this is possible and returns a value.
Is a question of logic you cannot park 2 cars in a single space (sorry for the comparision).
Hi Anonymous ,
Is this a one to many relationship?
When you refer that things are getting swapped do you mean that you see the many side on top of the relationship visualization?
I believe this is only a visual bug, because if you look at the bottom where there is the relationship type you should have many to one (so its also inverted) also check if the arrow direction on the relationship view is correct.
If the arrow is correct and the relationship type is also correct based on the order of the tables you are viewing everything is correct. (admit is frustrating the first times because it's not natural)
Hello,
Thank you for the help.
Yes this was a one to many where 1 contact id may be set as a volunteer__c on many jobs.
Getting exactly the same issue as in that other thread I linked:
After making the relationship, before pressing close:
After closing:
Is it at all possible this would affect the DAX? I can't seem to get the RELATED() function to work when using it with something like
table=FILTER(Contact,RELATED('Volunteer Job'[Id])<>'x')but RELATED() will work when I use it the other way around (FROM Job TO Contact) in something like:
table=FILTER(Volunteer Job,RELATED('Contact'[Id])<>'x')Its possible I am just writing this completely wrong though.
I am just trying to achieve a table where I can see all contacts that have job records only.
Thanks,
El
Hi Anonymous ,
The Related wotrks from the many to one side so in you case you are making the formula incorrectly. Let's break down the calculation you need.
You want all the Jobs that exist for a contact correct.
If you pick up you contact first you get a single value and then you try on the line to place all the related lines of Job this is not possible because you are getting a multiple value for each line so the result is an error.
If you do the other way around starting from the Jobs you are getting for each line of the job a single line of the Contact so this is possible and returns a value.
Is a question of logic you cannot park 2 cars in a single space (sorry for the comparision).