Most efficient way to identify and multiply

Hello Community,

I have a table which looks like this(dummy data):

The real table also contains more data points than just 'Value'.

For every calculation I need to multiply any value by the 'Factor' value.

Currently I am using a measure like this:

SUMX('Table', 'Table'[Value] * 'Table'[Factor])

I am searching for a more efficient way to achieve this.

I need to have the 'raw' data and pre-calculating these fields would bloat my model past the 1 GB limit unfortunately.

I also have a different situation where I need to sum the Factor column but only include the value once per TripId which I am currently achieving like this:

SUMX(VALUES('Table'[TripId]), CALCULATE(MAX('Table'[Factor])))

iI am experincing particularly slow performance with this last one and am wondering if there is a more efficient way to arrive at the factor as a scalar