How to calculate Contribution using DAX - Complex Business Problem - Please help

Dears Below are the worksheets with tables as below please download it here https://1drv.ms/x/s!AmJRjgj6xuQ_jQ7zPtvrWzrn05Kv
SQL View: a view created from SQL query from different tables
Unpivot SQL View: and unpivot version of table created in point 1 through power query
Report : Desired presentation


Objective: adding contribution column next to sales column where contribution is total sales - total prime cost

Advice required for above objective

Following action tried
With no success - Tried to calculate contribution in seprate colum in sql view an then unpivot renders wrong grouping through unpivot hence the results
with no success - Tried to calculate measures (wchih can be seen in data model) to achieve objective and then to making sets to delete extra column

Links added by OP

Appreciate your above advice here is the links to other sites

https://www.mrexcel.com/forum/power...ex-business-problem-please-help-new-post.html

https://forum.powerpivotpro.com/for...ing-dax-complex-business-senario-please-help/

Thank you
Did you take a moment to read https://www.excelguru.ca/content.php?184 ?

Pecoflyer said:

Thank you
Did you take a moment to read https://www.excelguru.ca/content.php?184 ?

Click to expand...

yes i did what u now really want me to do