How to Compare Department Sales vs Total Company Sales for Non-Sales Departments

[bclark]

Hello, 

I'm trying to create a matrix that shows department sales and payroll. If the department makes sales, then it should only show their sales. If the department does not make sales (like Admin or Maintenance), then it should show total sales. 

I was able to show this using the following measures. 

Total Sales = CALCULATE(Sales[Sales], All(Branches[Department]))

Sales by Department = IF(ISBLANK(Sales[Sales]),  [Total Sales], Sales[Sales])

And it worked, giving me this: 

However, I have now been asked to show "Packing" department sales as only a few different order types, instead of the total company sales. The rest of the non sales departments will still show total sales. 

I thought something like this would work: 

Packing Sales = CALCULATE(Sales[Sales], Sales[Order Type] = "Web" || Sales[Order Type] = "Service Center" || Sales[Order Type] = "Corporate")

Sales by Department = IF(ISBLANK(Sales[Sales]), If(CONTAINS(Branches, Branches[Department], "Packing"), [Packing Sales], [Total Sales]), Sales[Sales])

But it just shows Packing as blank now: 

Any thoughts on how I could do this? 

Thanks!