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...
AllisonKennedy
Community Champion
Community ChampionYou need to bring the product price into the fact table, either with measure or calculated column. You can try adding a new column to the Order Detail table;
Price = RELATED(Product[Price])
Then you can use that in the values in your visuals.