Forum Discussion

Iamnvt's avatar
Iamnvt
Continued Contributor
8 years ago
Solved

BOM Modeling

hi,   I have 3 tables: 1. Product Master data as dimension table for all material code 2. BOM: 1 Material contains many child components 3. Sales Order table: as fact table for orders of each pa...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Iamnvt,

Create a new table using DAX below.

Table = GENERATEALL(BOM,var productid =BOM[Product] return SELECTCOLUMNS(CALCULATETABLE(Sales,Sales[Product]=productid),"sales",Sales[Sales]))


Then create a table  visual as follows.




Regards,
Lydia