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 (weight) in related table, line by line.

I am using this formula: 

 

Total Weight = SUMX('public mrp_production', SUM('public mrp_production'[product_qty]) * RELATED('public product_template'[weight]))
 
The results line by line are correct, but the total is too small. What am I doing wrong? 
 
 
Any help much appreciated. 
 
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]))

2 Replies

  • 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]))

  • Pragati11's avatar
    Pragati11
    Super User
    6 years ago

    Hi Almantas32 ,

     

    Try modifying your DAX as follows:

    Total Weight = SUMX('public mrp_production',
    SUM('public mrp_production'[product_qty]) * RELATED(SUM('public product_template'[weight])))

     

    Thanks,

    Pragati