SUM sub items based on volume of a top item in the same table
All, I have the following data model (simplified) which show production output (table 3) per top level item. Another table is showing the BOM (bill of material) structure, table 4. Both are linked to a central item table (table 2), production data is linked to a date table (table 1). In my report I use a date and item filter. Final goal is to show for a selected period the usage of the different sub items. Example for Januari: I imagine I need a measure performing the following steps: 1. Calculate total volume for Top level item in selected period for selected items (slicer) 2. Calculate total required qty per sub item, based on step 1 X Qty per 3. Measure to use for the final result (see above) Anyone who could help with this? thanks, Jeroen
