Calculating from Values()

[paivers]

I'd like to take a set of values from another table, and do an expression on each one using a measure from this table. Kind of sum(values(table2[score])*[weight])), but of course you cannot multiply a table like that. Its kind of an iterator I am looking for. I cannot do it in the table2 calculated field, as that would not respect the slicers users to calculate the weight. Any advice appreciated. - Pete

 

[powerpivotpro]

SUMX and the other "X" functions are made for this sort of thing.

SUMX(Table2, [Measure from Table1])
or
SUMX(VALUES(Table2[ColA]), [Measure from Table1])

But I'd need to know more about the roles/contents of the two tables to be more specific.

SUMX() – The 5-point palm, exploding fxn technique « PowerPivotPro for more info.