Skip to Content
Oct 22, 2019 at 01:13 PM

Sum() distinct in Merged Dimmension



I would like to know how to correctly sum in merged dimensions.

For example, I merged the following objects: [ID],[Month] and [Total], in one of the universes there is an additional value so I expect that my Sum([Merged Total]) function will return only 66.84 and not the sum of the total in both querys.

I cannot specify the context in the sum because sometimes there is data in universe 1 that doesn't exist in universe 2 and vice verse.

Thank you guys.


bo.png (26.5 kB)