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.
CB and CB7 have an ID field that needs to be related to the ID column in Meta.
Also each of CB, CB7, and Meta have a date column that is related to the Date column in the Calendar table.
How can I achieve this?
Solved! Go to Solution.
Hi @gk2go ,
You cannot continue to create relationships for Meta[Date] and Calendar[Date] on top of your existing model, because this would create ambiguity.
Imagine a scenario where you create active relationships for Meta[Date] and Calendar[Date] on top of your existing relationships. Then when you apply filters from the Calendar table, the model will have two paths available for the model to choose from for filter propagation. One path is Calendar->CB and the other is Calendar->Meta->CB. This will create problems for the model as to which relationship path to use. So you can't do that.
We can temporarily active an inactive relationship with the help of USERELATIONSHIP. USERELATIONSHIP temporarily activates the inactive relationship (defined in the formula) and deactivates others to remove ambiguity:
Active vs inactive relationship guidance - Power BI | Microsoft Learn
USERELATIONSHIP function (DAX) - DAX | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @gk2go ,
You cannot continue to create relationships for Meta[Date] and Calendar[Date] on top of your existing model, because this would create ambiguity.
Imagine a scenario where you create active relationships for Meta[Date] and Calendar[Date] on top of your existing relationships. Then when you apply filters from the Calendar table, the model will have two paths available for the model to choose from for filter propagation. One path is Calendar->CB and the other is Calendar->Meta->CB. This will create problems for the model as to which relationship path to use. So you can't do that.
We can temporarily active an inactive relationship with the help of USERELATIONSHIP. USERELATIONSHIP temporarily activates the inactive relationship (defined in the formula) and deactivates others to remove ambiguity:
Active vs inactive relationship guidance - Power BI | Microsoft Learn
USERELATIONSHIP function (DAX) - DAX | Microsoft Learn
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |