UseRelationship not returning all rows of data

[cristinacraita]

Hello,

I need your help related to userelashionship in multiple data connection with a Calendar file.

In order to be able to return the value of an indirect relashinip data I use the following formula:

Report file contains tasks with different dates - assigned, in-work, closed 

Report Logged hours contains date of logged hours

All dates are connected to ,'Calendar'[Date] one to many, one way and only date "assigned" relashionship is active.

I need to plot some data against the logged date that no longer has hierarchy due to relashonsip with calendar date.

I created a measure to recreate a date filled of logged hours.

Logged date linked = CALCULATE(

LASTDATE(Report_LoggedHours[Logged Date]),

USERELATIONSHIP(Report_LoggedHours[Logged Date],'Calendar'[Date]))

Measure is not bringing unfortunately all the dates for each row and I cannot understand why.

Made a table to see what is missing and cannot figure out any difference between the rows. First row is task number, second is the measure above, then logged date from logged hours file, then date as used from calendar then assigned date (I was affraind relashinip is not used and that the calculation is using the active relashionship).

Same task with same date logged  can sometimes have results and sometimes not have a result passed by the measure.

New to power bi and I appreciate the help! Thank you!

https://drive.google.com/open?id=1dj0rXkm-cIzmKpH98CTeaYt4csSiUeLM

[v-easonf-msft · Accepted solution]

Hi , @cristinacraita 

According to you description ,maybe you are just missing a column of index .

You can try to add a index column in the query edit.

Here  is a sample I made:

URL: https://wicren-my.sharepoint.com/:u:/g/personal/michael_wicren_onmicrosoft_com/EaUQDUJyrmxEqWfQstZDn...

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.