Why isn't this USERELATIONSHIP measure working?

[michael_knight]

Hi,

Been trying to work this out and I'm struggling. Does anyone know why this measure isn't working? I feel like it's something plainly obvious 

Completions -  Count = SUM(Completions[Completions]) 

Completions - - Relationship = 
CALCULATE(Completions[Completions -  Count],
USERELATIONSHIP('Date'[Full Date], Completions[Date]) )

I checked the Date type to make sure it's the same in both tables, it is. I checked the data type of the sum column. I checked the relationships. Is there anything I'm missing?

https://www.dropbox.com/s/ftn5q3g388azvn5/Completions%20-%20Copy.pbix?dl=0

Cheers,

Mike

[AntrikshSharma]

In additon to Amit's answer you don't need USERELATIONSHIP if you only have 1 relationship between tables.

[michael_knight]

Hi @AntrikshSharma 

This is only a small part of the dataset, there is another dataset which I removed for the purpose of getting some help, and due to gdpr.

Cheers,

Mike

[amitchandak · Accepted solution]

@michael_knight , I made it 1 to M from date to table and it worked

Find attached file after signature

[michael_knight]

Knew it would be something as simple as that. Cheers @amitchandak