Lookup or Select return Empty

Hi All,
I have the supposed answer but the row does not provide the answer.

Tried both expressions of the INITIAL VALUE for the [Unit Cost column]:

  1. Any (Select(HW Products[Price],[Product Name]=[_thisrow].[Materials]))

  2. Lookup(“Materials”,“HW Products”,“Product Name”,“Price”)

HW Table:

Result:

App setup:

0 0 271
0 REPLIES 0
Top Labels in this Space