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.
Dear all,
Im new to PowerBi & these relationship things, hope to have your kind adivce on this problem.
The first relationship is Destination to Full code, the second is Origin to Full code,
When i put it into Matrix table, it shows correct city of Destination but incorrect of Origin.
Any comments would be highly appreciated.
Thanks
Solved! Go to Solution.
Correct, the second relationship is inactive. There can only be one active filter path between tables. However, you can use USERELATIONSHIP in a column or measure to specify the relationship that you want to use in a calculation.
@Anpham2812
You can only have one active relationship between tables, for inactive relationship please refer to the dax function.
USERELATIONSHIPP: https://docsmicrosoftt.com/en-usdaxxuserelationshipp-functiondaxx
Best,
Paul
Correct, the second relationship is inactive. There can only be one active filter path between tables. However, you can use USERELATIONSHIP in a column or measure to specify the relationship that you want to use in a calculation.
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 |
---|---|
112 | |
97 | |
78 | |
68 | |
55 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |