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 PaulDBrown ,
In case I had a dates table and some other dimension tables, linked to the fact table (despatch table), how should this measure be edited? I am asking because your measure is based on the pallet table (or product table).
Thank you
George
The table in SUMX should be whatever table is used in the visual to create the filter context of the visual. If more than one table is used in the visual, you will probably need to create an expression along the lines of:
SUMX(SUMMARIZE (FactTable, Dim Table 1 [Column1], Dim Table 2 [Column 2]), ....