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

[hafiz_asim]

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


Please follow the link to download model
https://1drv.ms/x/s!AmJRjgj6xuQ_jQ7zPtvrWzrn05Kv

 

[Joe4]

Cross-posted: https://www.excelguru.ca/forums/sho...sing-DAX-Complex-Business-Problem-Please-help

While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).

This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

For a more complete explanation on cross-posting, see here: http://www.excelguru.ca/content.php?184).

 

[hafiz_asim]

Thanks for above advice here is the link to other forum for the same post


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

https://www.excelguru.ca/forums/sho...roblem-Please-help&p=35472&posted=1#post35472