Forum Discussion
Multiplying values from different tabel
Hi, I am working on a report where I want to calculate theoretical usage for different ingredients used in production, based on sales numbers. Based on the model below, I have tried the follo...
Molin , Try like
Sumx(values(MenuComponent[MenuItem]),Max(IngredientComponent[Amount])*sum(CheckDetails[SalesCount]))