Forum Discussion
Solved
Relationship issues
Hi so I have an issue trying to link 2 tables together. The 2 tables I want to link are one about my orders and one about my hours which contains an orderID aswell for each hour entry. I need thi...
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 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.