Wrong Sum totals when using a SUM measure from two different Tables

[Dimi123]

Hi,

I have 2 calculated measures from 2 different tables:

- first measure: CALCULATE([Uitgifte in eenheid], DATESBETWEEN(Kalender[Dagen], NEXTDAY(SAMEPERIODLASTYEAR(LASTDATE(Kalender[Dagen]))), LASTDATE(Kalender[Dagen])))

- second measure: CALCULATE ([Kostprijs],LASTNONBLANK ( Kalender[Dagen], CALCULATE([Kostprijs)))

I have a third calculated measure that use these 2 measures: [first measure:]*[second measure]

Problem is that the total of this measure = sum([first measure])*sum([second measure]) not sum([first measure]*[second measure]).

I can not use SUMX because the measures are in 2 different tables ....

Can anyone help?

Thanks.

[v-sihou-msft · Accepted solution]

@Dimi123

You can still use SUMX(). You just need to create the SUMX() on the dimension table which will slice these two measures. For example, if you want to analyze this measure on Date level, you should write your measure like: 

=SUMX('DimDate',[Measure1]*[Measure2])

Regards,