I have an weird issue.
I want two measures in one analyisis and I don't have good results. If I make two reports (each report with one measure) I have good results.
Explain with an example.
Code // Year // Entity // Revenue(Measure A)
Total of measure A is 100
Code // Year // Entity // Revenue2(Measure B)
Total of measure B is 220
Code // Year // Entity // Revenue(Measure A) // Revenue2(Measure B)
Total of measure A is 100 but measure B is 412
Do you know any idea that can be?
Is it possible that Revenu2(Measure B) is filtered and return data only for the existing Code / Year / Entity existing for Revenue(Measure A) ?
Have a look at the generated physical SQL and check how the query is performed and if there is a inner join between the 2 excluding some values of Measure B because not existing in Measure A.