Forum Discussion
Helper IIIData Model
Super UserIt's possible that the Cost and Sub tables could be merged into the Product dimension somehow but having five fact tables isn't necessarily a problem.
Is there something specific that you're concerned about that seems wrong/incorrect?
Helper IIIMany thanks for your reply. My main concern is that the returns table aren't working in correlation with the dates and the average reviews are incorrect.
v-yingjlCommunity Support
Hi Jameswh91 ,
If it shows incorrect value based on these table relationships, perhaps it could be related to the cross filter direction(single and both), you can refer this document:
Adjusting Cross filter direction for a complex set of tables and relationships
In addition, a star schema table relationship could be more available, see:
Understand star schema and the importance for Power BI
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.