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] ) )
Hello mh2587 ,
Thank you for your reply. Please see the data model below.
I tried to remove the relationship, it didnt work.
Below oyu can see the different results between the manual and the DAX calculations.
Manual Calculation
| Product1 | Product2 | Product3 | |
| 150 | 100 | 75 | |
| 225 | 50 | 25 | |
| 75 | 50 | ||
| 100 | |||
| QtySum | 450 | 150 | 250 |
| PalletQty | 25 | 50 | 25 |
| PalletNum | 18 | 3 | 10 |
DAX calculation
| Row Labels | PalletNum |
| Product1 | 4.5 |
| Product2 | 1.5 |
| Product3 | 2.5 |
| Grand Total | 8.5 |
Thank you,
George