Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
@michael_knight , I made it 1 to M from date to table and it worked
Find attached file after signature
In additon to Amit's answer you don't need USERELATIONSHIP if you only have 1 relationship between tables.
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
@michael_knight , I made it 1 to M from date to table and it worked
Find attached file after signature