Forum Discussion
Solved
Getting Item Components Amount Based on Sales
I have a simple data model of pizza sales with three tables: 1. Fact_Sales 2. DIM_Product 3. DIM_Ingridients Every Pizza has a specific amount of ingredients. I would like to know ho...
Try
Ingredient Usage = SUMX ( 'DIM_Ingredients', VAR Sales = SUMX ( RELATEDTABLE ( 'FACT_Sales' ), 'FACT_Sales'[quantity] ) VAR Result = Sales * 'DIM_Ingredients'[Usage, KG] RETURN Result )
Try
Ingredient Usage =
SUMX (
'DIM_Ingredients',
VAR Sales =
SUMX ( RELATEDTABLE ( 'FACT_Sales' ), 'FACT_Sales'[quantity] )
VAR Result = Sales * 'DIM_Ingredients'[Usage, KG]
RETURN
Result
)
Unfortunately, I got blank values as a result.
I'm sharing a dataset just for any case.
LinkThe relationship between sales and product is invalid - the keys in the product table include the size whereas the sales table doesn't.
Thank you! You're a life saviour.
A silly mistake
