How can I resolve calc context from diferents queries?

[Former Member]

Hi Experts,

I have a dubt on a web Intelligence report about sum calc with dimensions from different queries. Let me give you an example.

Imagine we have from one query A:

And from query B:

We have City as merge dimension

And we need this result on the report:

The formula that I would writte to resolve it would be:

=Sum([Revenue] In ([City])) In ([Country])

But as we don't have the dimension Country on the query A I get 900 for all countries.

Can you help me to resolve that?,

Thank you

[former_member201488 · Accepted solution]

The solution is quite simple - use:

=forcemerge([Revenue])

Description of Forcemerge:

Includes synchronized (e.g. Merged) dimensions in measure calculations when the dimensions are not in the measure's calculation context.

HTH

NMG

[Former Member · Accepted solution]

Thank you Neil, I didn't know about that function and it resolves what I need.