SWITCH Function and Power Bi value calculations

[Axiomite]

Hi there, 

I've been running into problems where I use a switch function and it seem to be skewing my end result, especially where multiplication takes place with a value derived from a switch fucntion. I am unable to replicate my issue with my dummy data and cannot share the sensitive data. However I've attached a link to a pbix and dummy data in Excel. 
1. Instead of switch in Dax I can do this in SQL and and get my end result with basic Dax.

2. Being said I can solve with SQL, can you see if I took the correct approach with DAX, as this is bothering me and would love a better understanding? I get confused with the SUM, Dont summarize etc and this seems to have an effect on the end result. 

Link to dummy data: 

https://drive.google.com/drive/folders/1Kev8YiUNUUyCYRxW7XkxXYWlAagXwWL0?usp=sharing 

[Daniel29195]

@Axiomite 

can you explain the logic of the code you are trying to write ? 
like what do you want to calculate  ? 

[Axiomite]

@Daniel29195 
are you able access my shared documents? I've added another worksheet on the shared excel file, this will show you what I want to calculate. Thanks for your time.