Using Calculated table in a column to calculate discount

[Dicken]

Hello,
I have a workbook with three tables , I have created a calculated columns in the customer table for each
customer total discount .
What I would like to do is create a calculated column for total sales for each customer on the sales table.
and can't see what I have to do?

Any suggestions,

Richard.

[WideBoyDixon]

If you want this as an extra column in the Sales table, you could just put this formula in a new column:

Please Login or Register  to view this content.

If you want a summary table of customers and total sales then this spill formula would work:

Please Login or Register  to view this content.

WBD

[Dicken]

yes I know there are other way but I wanted to do it using a DAX calculated column, I haven't use Calclatedtable very much
and need to try and understand it, so thought calculating the sales for each row of the customer dim / lookup table would be good practice, but I'm stuck.

rd.