How to change the sum for a specific row when an IF statement wont work??

[rcb0325]

I have a table that is all summing correctly, but for the [WarehouseName] column, I want to change the calculation for [Total OnHand] to exclude certain "Planner Codes", but keep the current calculation for the other warehouses. My issue is the relationship between the two tables. I am unable to tell it
= IF( [WarehouseName] = "UNION WAREHOUSE", [Union Machine OnHand], [Total OnHand] )

The current calculation for the [Total OnHand] measure is :

 [Total OnHand] = CALCULATE( SUM('PROD fact InventorySummaryView'[OnHandPhysicalTons]), ALL('PROD dim PostedDateView'[PostedDateActualDate]) )

And I need to change the calculation only the "UNION WAREHOUSE" row to:

[Union Machine OnHand] = CALCULATE( SUM('PROD fact InventorySummaryView'[OnHandPhysicalTons]), ALL('PROD dim PostedDateView'[PostedDateActualDate]),

            FILTER( 'PROD dim InventoryDimensionView', 'PROD dim InventoryDimensionView'[WarehouseName] = "UNION WAREHOUSE"),

            FILTER( 'PROD dim ItemView', 'PROD dim ItemView'[PlannerCode] = "36M" ||

                    'PROD dim ItemView'[PlannerCode] = "37M" ||

                    'PROD dim ItemView'[PlannerCode] = "38M" ||

                    'PROD dim ItemView'[PlannerCode] = "39M" ||

                    'PROD dim ItemView'[PlannerCode] = "96M" )

These two measures by themselves work separately, but I am trying to combine them into one measure. 

Thanks in advance! 

[amitchandak]

@rcb0325 , a measure like

IF( max([WarehouseName]) = "UNION WAREHOUSE", [Union Machine OnHand], [Total OnHand] )

example of such calculation

Power BI How to get the P&L formatting right: https://youtu.be/C9K8uVfthUU

[rcb0325]

That did work! However the measure total is not summing correctly. Any suggestions? Thanks!