Forum Discussion

Almantas32's avatar
Almantas32
Helper II
6 years ago
Solved

Sumx issues

Hey Guys,   I have a problem with simple measure using sumx function. I am trying to calculate the total weight of manufactured goods, by multiplying the quantity (produt.qty) with the weigth (weig...
Need Help
  • amitchandak's avatar
    amitchandak
    6 years ago

    Almantas32 , Try like

    SUMX('public mrp_production', 'public mrp_production'[product_qty] * RELATED('public product_template'[weight]))

amitchandak's avatar
amitchandak
Super User
6 years ago

Almantas32 , Try like

SUMX('public mrp_production', 'public mrp_production'[product_qty] * RELATED('public product_template'[weight]))