Measure to calculate total cost of courses|Power Pivot|Excel Forum|My Online Training Hub

Hi,

I have a data model that contains 3 tables - a date table, a table containing a list of course attendees on three different types of courses, and a look up table that shows the cost to run each course.

I have managed to write some measures which show the number of attendees on each of the courses, and the number of times these courses have been run. I`m struggling to write a measure to show the course cost though.  I can bring the course cost into my pivot but get it to multiply by the number of times a specific course has been run.

Please see the attached spreadsheet.  Any help would be much appreciated.

Thanks, 

Brendan