Best method of creating a calculated column on the one side of a many to one relationship

I'm hoping the description sums it up, I've have two very simple tables one with sales one with products and their pirce,
I wanted to create a calcualted columns on the 'product ' one side and thought I would be able to do this uisng
'Calculatedtable', but couldn't. I have done it using :

Please Login or Register  to view this content.

which works and

Please Login or Register  to view this content.

which doesn't.

I was just hoping for some advice on approach and or direction to some info on many to one side calcuaations,

Richard, workbook attached .

Yes,
but I want to do using DAX, as I said wrapping the SUM of the many side in Calclulate works, I'll have to go through Matt Allington's book, I think that's where I came across it.

RD

Nothing really, I just have this I idea that I should be able to use RELATEDTABLE.

RD

True, Sorry , an oversight on my part.