Connecting Participant and Responses Survey Data to multiple Reference tables

[Anonymous]

Hey there,

I'm working on connecting L&D survey data. I have a participants and survey results table (not all participants took the survey) and would like to have them both connect to the WorkerMaster (Staff Directory) and SessionReference table. I've tried to make these connections but am not able to because it will not all multiple relationships to be active. This is the closest I've come to solving the problem, however, the SessionReference table still isnt connected to the Partipant list, so that when I filter based on session it does not show the accurate number of survey responses. 

Any ideas? Thank you!

[ybcrg · Accepted solution]

I am not sure what measure you may be trying to create like Count, Sum etc. but I have used USERRELATIONSHIP if active relationship does not exist.

=CALCULATE(SUM(TABLE1[AMOUNTCOLUMN]), USERELATIONSHIP(TABLE1[DATE COLUMN], DATETABLE[Date]))

You can try this syntax and accept the response if it works.

Thanks