Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |