Calculate Inbound =
CALCULATE( [Total Cost] ,
FILTER( ALL( Sheet1[Type] ) ,
Sheet1[Type] = "Inbound Shipping" ) )
The ALL in above filter seems to return distinct list of Type.
My understanding was that VALUES returns the distinct values?