Forum Discussion
Data Model Feedback
CB13 ,
I'm afraid in the current data model, you can't achieve this goal. The only way is as you said, to create 3 copies of owner table and build relationship between those copy table and Visit, Test and Item table.
Regards,
Jimmy Tao
v-yuta-msft Hi Jimmy,
The picture in my original post has a fake sample of the data. Here is a little more information about my current data model and the ambiguous reference in the picture below:
I unfortunately can't post a picture of the real example (this is a far simplified example).
Community ChampionIf you're using the final example it should work well if you're using a double crossfilter direction in your relationships between the facts tables.
The other option is the merge all three tables together in the query editor.
/ J