Forum Discussion

olegkazanskyi's avatar
olegkazanskyi
Helper II
3 years ago
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...
  • johnt75's avatar
    johnt75
    3 years ago

    Try

    Ingredient Usage =
SUMX (
    'DIM_Ingredients',
    VAR Sales =
        SUMX ( RELATEDTABLE ( 'FACT_Sales' ), 'FACT_Sales'[quantity] )
    VAR Result = Sales * 'DIM_Ingredients'[Usage, KG]
    RETURN
        Result
)
johnt75's avatar
johnt75
Super User
3 years ago

Try

Ingredient Usage =
SUMX (
    'DIM_Ingredients',
    VAR Sales =
        SUMX ( RELATEDTABLE ( 'FACT_Sales' ), 'FACT_Sales'[quantity] )
    VAR Result = Sales * 'DIM_Ingredients'[Usage, KG]
    RETURN
        Result
)