Calculate and Userelationship functions!

[sontt]

Hi everyone,

I have a table like that:

Createdate	billnumber	status	shipdate
27/01/2018	SO1	Done	28/01/2018
27/01/2018	SO2	Wait	28/01/2018
30/01/2018	SO3	Done	01/02/2018
05/02/2018	SO4	Done	06/02/2018
06/02/2018	SO5	Done	06/02/2018

and relationship: 

I want calculate how many bills was "Done" by shipdate, but measures not give me same results:

My measures:

count bills ship done:= CALCULATE(DISTINCTCOUNT(data[billnumber]),data[status]="Done",USERELATIONSHIP(data[shipdate],'date'[date]))

count bills ship done_v2:= CALCULATE(DISTINCTCOUNT(data[billnumber]),FILTER(data,data[status]="Done"),USERELATIONSHIP(data[shipdate],'date'[date]))

count bills ship done_v3:=CALCULATE([count bills done],USERELATIONSHIP(data[shipdate],'date'[date]))

count bills done:=CALCULATE(DISTINCTCOUNT(data[billnumber]),FILTER(data,data[status]="Done"))

Measure count bills ship done_v2 return incorrect result but i dont understand why.

Please tell me why count bills ship done_v3 returns correct result but count bills ship done_v2 didnt

Sorry about my English.

Thanks in advance!

[v-yulgu-msft]

 Hi @sontt,

Based on my test, both count bills ship done_v3 and count bills ship done_v2 return correct result.

In above image, [Month] is a calculated column added in 'data' table.

Month = MONTH(data[shipdate])

Best regards,

Yuliana Gu

[sontt]

Sorry bro, my active relationship is date[CreateDate] - date[Date]. Can u help me check my file here please:

https://drive.google.com/open?id=1CbusjEwpv-wh0WXr4Iz3xBZDTZ4Jwfdv

Thank you so much