Power Pivot multiply 2 columns each in a separate but related table

Hi,
I'm trying to multiply two columns, (YouTube tutorial), and it's all worked in the past but now when trying to repeat i get error message,
This is what I originally entered and it worked on my first attempt;

=RELATED('Cookie Types'[Profit per]*Orders[Units Sold], now when I try it continually insists on entering a final parenthesis and then underling in red.

I've changed the order to ; =Orders[Units Sold]*RELATED('Cookie Types'[Profit per]), and this returns the correct result.


I've attached the workbook, and hope someone can help.

Richard.

Thank you,
Problem solved.