Forum Discussion

Continued Contributor

5 years ago

Solved

Convert a Measure to a Calculated Column

I have 2 disconnected tables: ProductValueLookup Column A 2 ? A 3 ? B 4 ? B 5 ? and ProductValue2 A 3 A 2 A 2 B 1 I can create a measure to l...

5 years ago

Lookup Column = 
CALCULATE(
    SUM( Table2[Value2] ),
    TREATAS( { ( Table1[Product] ) }, Table2[Product] )
)

Community Champion

5 years ago

Lookup Column = 
CALCULATE(
    SUM( Table2[Value2] ),
    TREATAS( { ( Table1[Product] ) }, Table2[Product] )
)