SUMX with Related Column Assistance

[apuype]

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

50	0.03	0.03
539	0.5	4.49
116	0.75	1.45
1632	0.5	13.60
5180	0.25	21.58

Thank you! 

[v-rongtiep-msft]

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]

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