Forum Discussion

apuype's avatar
apuype
Frequent Visitor
3 years ago

SUMX with Related Column Assistance

Good afternoon, looking for some guidance on a SUMX formula as the totals are not working. Wondering if I need to change to a different function to calculate these? 

Total Hours Saved = SUMX(order_post_hist,order_post_hist[Order Count]*RELATED('Load Metrics'[Time Per Order (M)]))/60

 

If I throw the same values in excel

500.030.03
5390.54.49
1160.751.45
16320.513.60
51800.2521.58

Thank you! 
Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi apuype ,

    Please have try.

    Create a measure.

    measure =
VAR _1 =
    (
        MAX ( 'order_post_hist'[Order count] )
            * MAX ( 'Load Metrics'[Time Per Order(M)] )
    ) / 60
RETURN
    SUMX ( ALL ( 'order_post_hist' ), _1 )

     

    How to Get Your Question Answered Quickly 

     

    If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

     

    • apuype's avatar
      apuype
      Frequent Visitor
      3 years ago

      Thank you, it will not accept as my load metrics value needs to use the related function - I have tried inserting it a few ways but it will not take