Forum Discussion
divide between two tables
Hello Community, I would appreciate your help with the below. I want to understand how I can divide the "Despatch"[Quantity] by the "Pallet"[Pallet_Quantity]. I have built a relationship ...
In that case you need the following measure:
Pallett number = SUMX ( 'Product Table', DIVIDE ( [Despatch Quantity], [Pallet Quantity] ) )
Well, DIVIDE does at it says. So the division is within the filter context and over the totals.
SUMX, on the other hand, performs the calculation (in this case the DIVIDE) within the filter context (so row by row) and then sums the result of each calculation to deliver the total. Make sense?