I have to queries: (D for dimension, M for measure)
Q1 returns D1, D2, M1 (D1 is order line item)
Q2 returns D1, D3 (D3 is the order number)
Merge Q1 with Q2 on D1 and try to display (D3, M1), we get M1 as the sum of everything. Any ideas? Thanks.