Hey Steve

Thank you so much for pointing me in the right direction. It helps when you have the correct search term to look for.

Used the link below in my first google search and that helped me solve my problem

http://www.purplefrogsystems.com/blog/2008/04/semi-additive-measures-using-sql-server-standard/

Awesome help..