Forum Discussion
Online orders data schema
Hi all, I'm trying to understand how to develop an effective data model to support my business needs. I understand that from research the star schema is one of the best methods, however I am unab...
amitchandak
Super User
Super UserAnonymous , If product to order details is 1 to many
A new measure like
sumx(OrderDetail, related(Product[retail price]))
or
sumx(OrderDetail, related(Product[retail price])* OrderDetail[quantity])
or
sumx(relatedtable(Product),Product[retail price])