Help with measure or calculated column

[Anonymous]

I have three tables in Power Pivot for Excel. One fact table named 'ProductionPalletSummaryNew'. One dimension table named 'Cases Per Pallet' and another dimension table named 'Lines'. ProductiionPalletSummaryNew table and Cases Per Pallet table related by ProductID key. ProductionPalletSummaryNew is related to Line table by Process Order key. I am using this measure named # of pallets to sum cases and it work fine. However, I want to be able to sum cases by [ProductionDate], [ProductID], [Shift], which are located within 'ProductionPalletSummaryNew' table and as well by [Line] which is located within 'Lines' table and finally divide the the number of cases by [Cases Per Pallet] field located in Cases Per Pallet table. I am able to accomplish this task using a VLOOKUP function adjacent to a pivot table. I would prefer to use a measure or a calculated column to acomplish this end result. I would greatly appreciate your help and time. Below is a copy of the pivotable.

=IFERROR(E8/VLOOKUP(D8,tbl_Cases_Per_Pallet,3,FALSE),"0")

# of pallets:=SUMX(VALUES(ProductionPalletSummaryNew[ProductID]),SUM(ProductionPalletSummaryNew[Cases]))/SUM('Cases Per Pallet'[Cases Per Pallet])

[technolog]

Can you please tell me if the problem is still relevant? If you managed to solve it in some way, please write here how you solved this problem. Then it will be possible to mark this problem as solved.

If not, it may make sense to ask the question again, thus confirming the relevance of this problem.