Userelationship not giving expected results

[DataSkills]

Hi, 

I am attemping to use the "Userelationship" function in DAX to utilise an inactive relationship as per THIS youtube instruction video from Sam McKay. 

I have replicated this using a basic model (attached in Google Drive - click the download icon at top right to save). This model has a date table and a fact table with Name, DateRecorded, DateOccurred and Qty. 

The active relationship is Date.Date-->Fact.DateOccurred. There is an inactive relationship between Date.Date-->Fact.DateRecorded. 

As per the video instructions, I have set up 2 measures - one using the primary relationship (Qty by DateOccurred) and the other using the inactive relationship (Qty by DateRecorded). 

However, when I put these into a table, I am not getting the results I expected.  In my table, I have the Date.Date field, the Qty field (summed), and then the 2 measures. I was expecting to see differences in the Qty by DateOccurred measure and the Qty by DateRecorded measure, but this is not the case. 

What I would have expected is something like this:

Date	Qty by DateOccurred	Qty by DateRecorded
28 October 2016	637
13 December 2016	874	637

 What am I doing wrong? Thank you in advance...

[DataSkills]

After that change, here is what my table looks like:

[DataSkills]

Thank you @OwenAuger ! 

I didn't even notice that little (but crucial) detail! I made the mistake of assuming PBI would get that right automatically. 

[OwenAuger · Accepted solution]

Hi @DataSkills 

Change the inactive relationship to 1:many single-directional (same as the active relationship) and this should fix it.