Total Margin Items
Total Margin for Power BI in Sales_opps_won
Total Margin = IF([ProdType]= "product" , [qty]*[margin], [Margin])
Total Margin for SSMS in Sales_opps_won
sum(CASE WHEN [ProdType] = 'Product' then ISNULL([Margin],0) * ISNULL([Qty],0) ELSE [Margin] END) as 'Total Margin'
I can explain more on it if need be
last updated december 2015