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, I'm trying to understand how USERELATIONSHIP() works and went into question how does it decide which undefined active relationship to use when there is more than one to the same table.
In my example both tables 'users' and 'usage' have active relationships to the table 'calendar' and one inactive 1 to 1 relationship between them. I have two measures created:
Measure_usage = calculate(sum(usage[usage]), userelationship(usage[user_id], users[user_id]))
Measure_users = calculate(count(users[user_id]), userelationship(usage[user_id], users[user_id]))
Then I create two table visuals with calendar[date] field and those measures to test which calendar relationship will it use - results are that both measures use relationship users[created_at]<->calendar[date].
Could anyone explain why is it so?
@Alex_Ra
Your model has to be amended by adding a new dimension table for users and creating relationships with usage and users tables. Remove current inactive relationship between these two tables to avoid ambiguity.
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
This is just an example model to show this issue when PowerBI decides itself which relationship to use.
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 | |
105 | |
79 | |
68 | |
63 |
User | Count |
---|---|
148 | |
107 | |
106 | |
84 | |
70 |