Stock usage over time

Hi Anonymous ,

Maybe you can try this:

1. Do not create relationships using 'Menu Table', and create 'Many-to-Many' relationship between 'Recipes Table' and 'Menu Item Sales Table' instead.

2. Create a measure.

Ingredient Sales =
SUMX (
    ItemSales,
    CALCULATE (
        MAX ( ItemSales[Qty Sold] ),
        ALLEXCEPT (
            'Granular Recipes',
            'Granular Recipes'[Item Name],
            'Granular Recipes'[Ingredient]
        )
    )
        * CALCULATE (
            MAX ( 'Granular Recipes'[Quantity] ),
            ALLEXCEPT ( ItemSales, ItemSales[Date], ItemSales[Item Name] )
        )
)

Best Regards,

Icey

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.