Forum Discussion
Relationship issues
I am advising that you can't create that relationship. Can you create a dim_melting from the fields that can join to both of the tables, to provide the required filtering.
If the join is for a specific measure, you can use CALAICLATE(...,USERELATIONSHIP()) to activate it for that measure.
Modelling will be the best option
I dont really understand how you advise me to join it to both tables cause when I try it doesnt allow it due to the same reason. Providing a bigger part of my model could you possibly provide a more specific answer?
I am aware I cannot edit it in this file btw
I am advising that you can't create that relationship. Can you create a dim_melting from the fields that can join to both of the tables, to provide the required filtering.
If the join is for a specific measure, you can use CALAICLATE(...,USERELATIONSHIP()) to activate it for that measure.
Modelling will be the best option
Thank you for your assistance I managed to get it to work perfectly now.