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] ) )
Can you please upload the screenshot of your model or clear the relation between the tables?